function (table
as table,column
as text) as table
table
, where a column
is a list of values, splits the list into a row for each value. Values in the other columns are duplicated in each new row created.Table.FromRecords({[Name="Bob", Discount=0.15],[Name="Jim", Discount=0.15],[Name="Paul", Discount=0.15]})