Courses / Power Query (Get & Transform)
31. Group By
Aggregating rows with Group By to produce summaries like sums, counts, or nested tables.
1 min read Chapter 31 of 43
Power Query M
Group By
Combining rows by one or more keys to produce summary values (sums, counts) or nested tables.
"I want one row per customer with their total sales instead of 10 rows for every sale."
Group By in Power Query takes a table, clusters rows that share key values, and produces aggregated results like totals, counts, or nested tables per group.
"I want one row per customer with their total sales instead of 10 rows for every sale."
Group By in Power Query takes a table, clusters rows that share key values, and produces aggregated results like totals, counts, or nested tables per group.