Day 12 — 12 practice questions
Everything from the first eleven days. Write your own answer before opening each box.
How to use this page
Each question shows a working measure. Read the question, write your own first, then run the box. A different measure that returns the same number is a good sign.
Every measure on this page runs against the model below — a fact table and three dimensions, the same shape you would build in Power BI Desktop.
1. Total revenue
2. How many orders?
3. Average order value, rounded
4. Revenue for one region
5. Two filters at once
Accessories sold in the West.
6. Total margin
7. Margin percentage by category
8. Percentage of total by region
9. Last year, side by side
10. Rebuild revenue row by row
Qty times the product’s price, on each row, then totalled.
11. Revenue from large orders only
12. A full report row
Where to go next
You now have the DAX half of Power BI — the half that takes longest to learn and the half interviews ask about. The rest is the application itself: Power Query’s interface, building visuals, publishing, refresh schedules and workspaces. That is what the Power BI course covers.
The SQL tutorial pairs well with this — most Power BI models are fed by a SQL query, and filtering early in SQL is the same performance idea as filtering early in Power Query.
Try these yourself
- Redo question 5 for North computers instead.
- Write a measure for total units sold in 2025.
- Work out the average unit price across the whole model.
- Break Sales and Last Year down by Product[Category].
- Find what share of revenue comes from the single largest region.