Power Query practice: Group By & Table Aggregations
Chapter 12 · 5 questions · included in full access
Question 1 · easy
Total quantity per region
Solve it in your browserSummarise Orders to one row per Region with Total Qty = sum of Qty. Use Home ▸ Group By (Basic).
Question 2 · medium
Orders per rep
Solve it in your browserHow many orders did each Rep take? Group by Rep with a Count Rows column named Orders.
Question 3 · medium
Several calculations at once
Solve it in your browserGroup by Category (Advanced) with three aggregations: Orders (Count Rows), Total Qty (Sum of Qty) and Avg Price (Average of UnitPrice).
Question 4 · medium
Two group columns
Solve it in your browserGroup by Region and Category (Advanced ▸ Add grouping) with Total Qty = sum of Qty.
Question 5 · medium
What is _ inside Group By?
Solve it in your browserIn
each Table.RowCount(_)inside a Group By step, what is_?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing