Assignment A06 — The Time Machine

Skills assessed. CALCULATE with ALL · a marked date table · time intelligence · conformed dimensions · joining the targets fact · attainment.

Submit: A06_LastFirst.pbix. Worth 20 points. Start from your A05 model — this assignment completes it into the full Module-2 machine, which Project 1 and the capstone both build on.

Scenario

The VP's board slide needs three families of numbers your model cannot yet produce: shares of total, growth versus last year, and performance against finance's targets. Everything below is the machinery those numbers stand on.

Requirements

Turn off auto date/time (File → Options → Data Load → current file), then create the calculated table Dates = CALENDAR(DATE(2023,1,1), DATE(2026,12,31)) with Year, Month, and Month Number columns; sort Month by Month Number; Mark as date table; relate Dates[Date] → Sales[OrderDate]. Verify: 1,461 rows.
Conformed dimensions: Regions = DISTINCT(Stores[Region]) and Categories = DISTINCT(Products[Category]), related so each filters both its facts (Regions → stores and targets; Categories → products and targets).
Load targets (targets.csv, 1,080 rows) and relate TargetMonth → Dates[Date].

Six new measures, exact names:

Measure	Check value (context noted)
`% of Total Revenue`	Furniture row of a category table: 37.12%; column sums to 100%
`Revenue YTD`	June 2025 cell: $9,916,580.47
`Revenue LY`	Filtered to 2025: $18,444,998.18
`YoY Growth %`	Filtered to 2025: +12.03%
`Target Revenue`	Filtered to 2026: $10,722,574.96
`Attainment %`	Filtered to 2026: 107.39%

Page "Performance": a Year slicer (from Dates) · a card for YoY Growth % · a monthly line of Revenue with Revenue YTD · a bar of Attainment % by Region (from the Regions dimension) with a constant line at 100%. With 2026 selected: every attainment bar above the line, West on top at 112.72%.

The two traps, named (1) Your % of Total denominator must remove category filters only — if selecting a year changes your percentages to nonsense, you wrote ALL too wide. (2) Do not relate targets to stores or products directly; both attempts offer many-to-many, and both are wrong. The conformed dimensions exist precisely so you never click OK on that dialog.

Checklist (what the grader checks)

#	Check	Points
1	Dates table: 1,461 rows, marked as date table, related to sales	3
2	Regions (6 rows) and Categories (5 rows) dimensions, correctly related	3
3	Targets loaded (1,080 rows), related to Dates; no fact-to-fact relationships anywhere	2
4	Six measures exist by exact name	3
5	All six check values match under the stated contexts	5
6	"Performance" page: slicer, card, line + YTD, attainment bar with 100% line	3
7	File named `A06_LastFirst.pbix`	1

Before you submit

Select 2025 in the Year slicer and read YoY: +12.03%. Select 2026: attainment appears and every bar clears the line. If a bar chart shows one giant bar labeled "blank," a dimension relationship is missing.
Read your % of Total column and add it in your head: 100, or the denominator leaks.
Save, close, reopen, verify.