Group By with Multiple Aggregations in Power Query M

Groups rows and computes several aggregations (sum, average, count) on different columns in a single step.

Table TransformationsIntermediategroup byaggregationsumaverage

Power Query M code

let
    Source = YourTable,
    Grouped = Table.Group(Source, {"GroupColumn"}, {
        {"TotalSales", each List.Sum([Sales]), type number},
        {"AverageSales", each List.Average([Sales]), type number},
        {"OrderCount", each Table.RowCount(_), Int64.Type}
    })
in
    Grouped

Notes

Add or remove aggregation records in the list to change which measures are calculated per group.

Requirements

A table with a column to group by and one or more numeric columns to aggregate.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Group By with Multiple Aggregations.