Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Quarter to date. DATESQTD('Date'[Date]) returns the dates from the first day of the quarter up to the last visible date. Pass it to CALCULATE as a filter, or use TOTALQTD(expression, 'Date'[Date]), which does both in one step. On the total row the last visible date is December 31, so the total is the fourth quarter.
Orders QTD = CALCULATE([Orders], DATESQTD('Date'[Date]))The warehouse plans stock by quarter. Each month, the planner wants to see how many units have shipped so far in the current quarter.
Write the measure Units QTD on order_items: Units from the first day of the row's quarter up to the end of the row's month. Build it on the Date table's 'Date'[Date]. The matrix shows Units and Units QTD 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