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
- intermediate~8 minPro
Summarise orders by region (kite shop)
Group by Region with order count, total quantity and average unit price, sorted by region.
- intermediate~8 minPro
Count distinct customers per product (kite shop)
For each product, count how many different customers ordered it.
- advanced~10 minPro
Show each region's share of total revenue (kite shop)
Total revenue per region, then each region's percentage of the grand total.
- intermediate~8 minPro
Find each region's first and last order date (kite shop)
Group by Region with the earliest and latest OrderDate as real dates.