Power QueryExercises

Group By

Collapsing rows that share key values into one row per group, with aggregations like sum, count or average.

Each output row holds one combination of key values plus the aggregations you define. The All Rows aggregation keeps each group's rows as a nested table, which enables per-group work such as ranking or top N. Rows with null keys form their own group.

In the Power Query editor

Home or Transform → Group By, with Basic and Advanced modes, which writes Table.Group.

Learn more

Related functions

Practise it

Related terms