Comment on page
Table.AddColumn
Adds a column with the specified name. The value is computed using the specified selection function with each row taken as an input.
function (table
as table,newColumnName
as text,columnGenerator
as function, optionalcolumnType
as nullable any) as table
Adds a column named
newColumnName
to the table table
. The values for the column are computed using the specified selection function columnGenerator
with each row taken as an input.Table.Transformation
Add a column named "TotalPrice" to the table with each value being the sum of column [Price] and column [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]})
Last modified 5yr ago