Practice — Mild · Context Rehearsal

Skills focus. The lesson's builds, rebuilt by hand: the date table, CALCULATE with ALL, YTD, and YoY — with the answer key open.

Ungraded. Start from your A05 model. Checkpoints are verified figures.

Tasks

Turn off auto date/time for the file, then create Dates = CALENDAR ( DATE(2023,1,1), DATE(2026,12,31) ) with Year and Month columns; sort Month by month number; Mark as date table; relate to Sales[OrderDate]. Checkpoint: 1,461 rows.
Build percent of total: % of Total Revenue = DIVIDE ( [Total Revenue], CALCULATE ( [Total Revenue], ALL ( Products ) ) ). Table it against Category. Checkpoint: Furniture 37.12% … Decor 7.51%, and the column sums to 100%.
Revenue YTD = TOTALYTD ( [Total Revenue], Dates[Date] ) in a monthly table for 2025. Checkpoint: June row $9,916,580.47; December row equals the full year's $20,663,253.89.
Revenue LY and YoY Growth % exactly as the lesson wrote them. Add a Year slicer. Checkpoint: 2025 selected → +12.03%. 2024 selected → +13.93%.

Hint — my YTD equals plain revenue everywhere

Either the visual has no date field giving the measure a window to accumulate in (add Month from the Dates table — not from sales), or the Dates table is not marked. Both symptoms look identical; check the visual first, the marking second.

Reflection

In step 2, why must the Month field in your visuals now come from Dates rather than from sales' own OrderDate hierarchy?
Step 4's checkpoint for 2024 (+13.93%) was not in the lesson. Where did the check come from, and what does that tell you about how the course's numbers work?