Running total over all dates
A running total adds everything up to the end of the cell, across year boundaries. The filter is every date up to the cell’s last date: FILTER(ALL(Date[Date]), Date[Date] <= MAX(Date[Date])).
MAX(Date[Date]) is evaluated in the cell, before FILTER iterates. Inside FILTER, ALL(Date[Date]) provides every date, so the condition can reach back past the cell.
Your task
Write Sales Running Total: the Sales Amount of every date up to and including the last date of the cell.
About this exercise
You practise filter over all dates with CALCULATE, FILTER, ALL and MAX. 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 Running Total, 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 Running Total =The result to build
| Year › Quarter | Sales Running Total |
|---|---|
| 2024 | 127,658.15 |
| Q1 | 24,861.05 |
| Q2 | 63,485.35 |
| Q3 | 98,398.15 |
| Q4 | 127,658.15 |
| 2025 | 257,394.45 |
| Q1 | 162,405.60 |
| Q2 | 187,520.70 |
| Q3 | 217,108.35 |
| Q4 | 257,394.45 |
| Total | 257,394.45 |
Last updated 10 November 2026
Opening the exercise…