function (table
as table,newColumnName
as text,columnGenerator
as function, optionalcolumnType
as nullable any) as table
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.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]})