Table.AggregateTableColumn
Syntax
Table.AggregateTableColumn(table as table, column as text, aggregations as list) as table
About
Aggregates tables in 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.
Example 1
Aggregate table columns in [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]
.
Usage
Table.AggregateTableColumn(
Table.FromRecords(
{
[
t = Table.FromRecords({
[a = 1, b = 2, c = 3],
[a = 2, b = 4, c = 6]
}),
b = 2
]
},
type table [t = table [a = number, b = number, c = number], b = number]
),
"t",
{
{"a", List.Sum, "sum of t.a"},
{"b", List.Min, "min of t.b"},
{"b", List.Max, "max of t.b"},
{"a", List.Count, "count of t.a"}
}
)
Output
Table.FromRecords({[#"sum of t.a" = 3, #"min of t.b" = 2, #"max of t.b" = 4, #"count of t.a" = 2, b = 2]})
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for