Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.AggregateTableColumn

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

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  

Arguments

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.

Example

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
© 2018 Microsoft