function (table
as table,column
as text,aggregations
as list) as table
table
[column
] into multiple columns containing aggregate values for the tables. aggregations
is used to specify the columns containing the tables to aggregate, the aggregation functions to apply to the tables to generate their values, and the names of the aggregate columns to create.[t]
in the table {[t = {[a=1, b=2, c=3], [a=2,b=4,c=6]}, b = 2]}
into the sum of [t.a]
, the min and max of [t.b]
, and the count of values in [t.a]
.Table.FromRecords({[#"sum of t.a" = 3, #"min of t.b" = 2, #"max of t.b" = 4, #"count of t.a" = 2, b = 2]})