Table.AggregateTableColumn

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Aggregates tables nested in a specific column into multiple columns containing aggregate values for those tables.

Table.AggregateTableColumn(table as table, column as text, aggregations as list) as table  

ArgumentDescription
tableTable to aggregate.
columnColumn containing nexted table to aggragate.
aggregationsSpecify 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.
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"}})  

sumoft.aminoft.bmaxoft.bcountoft.ab
32422
Show: