Sales by ship date with USERELATIONSHIP
Sales has two dates: Order Date and Ship Date. Both relate to Date[Date], but only one relationship can be active, here the order date. The ship date relationship exists but is inactive (a dashed line in Power BI).
CALCULATE([Sales Amount], USERELATIONSHIP(Sales[Ship Date], Date[Date])) switches to it for one calculation. Orders placed in late December and shipped in January move to the next month.
Your task
Write Shipped Sales: the Sales Amount by ship date instead of order date.
About this exercise
You practise inactive relationships with CALCULATE and USERELATIONSHIP. 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, Shipped Sales, 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
Shipped Sales =The result to build
| Year › Quarter | Shipped Sales |
|---|---|
| 2024 | 127,247.15 |
| Q1 | 24,834.05 |
| Q2 | 38,651.30 |
| Q3 | 31,576.80 |
| Q4 | 32,185.00 |
| 2025 | 129,923.10 |
| Q1 | 34,661.20 |
| Q2 | 25,565.80 |
| Q3 | 29,526.20 |
| Q4 | 40,169.90 |
| Total | 257,394.45 |
Last updated 10 November 2026
Opening the exercise…