Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Same period last year. SAMEPERIODLASTYEAR('Date'[Date]) returns the visible dates moved back one year: March 2025 becomes March 2024. Used as a CALCULATE filter, it evaluates a measure for last year's version of the row. DATEADD('Date'[Date], -1, YEAR) gives the same dates.
Target PY = CALCULATE([Target], SAMEPERIODLASTYEAR('Date'[Date]))Brightline's order history starts in 2025, but finance loaded 2024 revenue by month and region into revenue_2024. The CFO wants each 2025 month next to the same month of 2024.
Write the measure Revenue PY on order_items: the revenue of the same period one year earlier. 2024 revenue is in the library measure [Revenue 2024], and revenue_2024[month] is related to 'Date'[Date]. The matrix shows Revenue and Revenue PY 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