Table.AddColumn

Table.AddColumn(table as table, newColumnName as text, columnGenerator as function,  optional columnType as nullable type) as table

将名为 newColumnName 的列添加到表 table。使用指定的选择函数 columnGenerator(它将每行作为输入)来计算列的值。

示例:

将名为 "TotalPrice" 的列添加到表，其中每个值是列 [Price] 和列 [Shipping] 的和。

使用情况:

Table.AddColumn(Table.FromRecords({[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0, Shipping = 10.00], [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0, Shipping = 15.00], [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0, Shipping = 10.00]}), "TotalPrice", each [Price] + [Shipping])

输出:

Table.FromRecords({[OrderID=1,CustomerID=1,Item="Fishing rod", Price=100,Shipping=10,TotalPrice=110],[OrderID=2,CustomerID=1,Item="1 lb. worms", Price=5,Shipping=15,TotalPrice=20],[OrderID=3,CustomerID=2,Item="Fishing net", Price=25,Shipping=10,TotalPrice=35]})