Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Year to date. TOTALYTD(expression, 'Date'[Date]) evaluates the expression from the start of the year to the last date visible in the row. It needs the date column of the Date table, so the row's month can be widened to the whole year so far. On the total row, the last visible date is December 31, so the total is the full year.
Target YTD = TOTALYTD([Target], 'Date'[Date])
Brightline's main supplier pays a volume rebate once enough units are bought in a calendar year. Procurement wants to see, month by month, how many units Brightline has sold so far this year.
Write the measure Units YTD on order_items: Units from January 1 up to the end of each row's month. Build it on the Date table's 'Date'[Date]. The matrix shows Units and Units YTD by month of 2025.
Matrix
Updates as you typeFilters on this visual'Date'[Year] is 2025
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe