Table.AggregateTableColumn

Aggregate tables are combined into multiple columns that contain aggregate values for the tables. The "aggregations" function is utilized to identify the columns containing the tables to aggregate, th...

Syntax

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

About

Aggregate tables are combined into multiple columns that contain aggregate values for the tables. The "aggregations" function is utilized to identify the columns containing the tables to aggregate, the specific aggregation functions to be applied in order to generate their values, and the names of the aggregate columns to be formed.

Explanation

Aggregate the columns in Table T into the sum of column A, the minimum and maximum of column B, and the count of values in column A. This can be done using the Power Query MTable.AggregateTableColumn function. The input table should be created using Table.FromRecords with the specified structure. The output table will contain the calculated values for the sum of column A, the minimum and maximum of column B, and the count of values in column A, along with the value of column B.