Test yourself under real exam conditions: 50 timed questions, 60 on the clock, pass mark 70%%. Instant score with a full review of everything you got wrong. Free — no account needed.
Exam details
Column: computed row-by-row at refresh; stored in model; uses row context.
Measure: computed at query time; aggregates; uses filter context.
Total Sales := SUM(Sales[Amount])
Customers := DISTINCTCOUNT(Sales[CustomerId])
PY Sales := CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date]))
YoY % := DIVIDE([Total Sales] - [PY Sales], [PY Sales])