Comment on page

Table.AddColumn

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, optional columnType as nullable any) as table
Description
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.
Category
Table.Transformation
Examples
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]})

RowExpression.From

Table.AddIndexColumn

Last modified 5yr ago