Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Shifting dates with DATEADD. DATEADD('Date'[Date], number, interval) moves the visible dates by a number of days, months, quarters or years; a negative number moves back. Whole months stay whole, so a full quarter moves to the full quarter before it. Used in CALCULATE, it shows a measure for the shifted period.
Orders Last Month = CALCULATE([Orders], DATEADD('Date'[Date], -1, MONTH))The quarterly review compares each quarter of 2025 with the one before it. The finance lead wants the previous quarter's revenue on the same line.
Write the measure Revenue PQ on order_items: Revenue of the quarter before the row's quarter. Use DATEADD on 'Date'[Date]. The matrix shows Revenue and Revenue PQ by quarter of 2025; Q1 has nothing before it, so its Revenue PQ is blank.
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