Year-over-year growth in percent
Growth compares this period with the same period last year: (this year minus last year) divided by last year. Two variables keep it readable.
Where last year is BLANK, DIVIDE returns BLANK instead of an error, so 2024 stays empty instead of showing a meaningless number.
Your task
Write Sales YoY %: (Sales Amount minus last year’s Sales Amount) divided by last year’s Sales Amount.
About this exercise
You practise var, divide and last year with VAR, SAMEPERIODLASTYEAR and DIVIDE. The exercise runs on a small bike-shop model with a Sales fact table and Product, Customer and Date dimensions, the same star schema in every lesson.
Your measure, Sales YoY %, fills a Power BI-style matrix grouped by Date[Year] and Date[Quarter]. As in a real report, each cell evaluates the measure in its own filter context, and the subtotals and the grand total are evaluated again in theirs rather than added up. When you check your answer, every cell is compared with the expected value, wrong cells are marked, and the hint is about the mistake you made.
Measures that already exist in the model: Sales Amount. Reference them in square brackets, for example [Sales Amount].
Where you start
Sales YoY % =
VAR CY = [Sales Amount]
VAR PY =
RETURNThe result to build
| Year › Quarter | Sales YoY % |
|---|---|
| 2024 | |
| Q1 | |
| Q2 | |
| Q3 | |
| Q4 | |
| 2025 | 1.6% |
| Q1 | 39.8% |
| Q2 | -35.0% |
| Q3 | -15.3% |
| Q4 | 37.7% |
| Total | 101.6% |
Last updated 10 November 2026
Opening the exercise…