Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
The regional managers want 2025 growth over 2024 by region. The AI assistant built YoY Growth, left it blank for every region, and suggested dropping the column from the pack.
AI assistant: “YoY Growth is blank for every region. Brightline's order history starts in 2025, so there is no prior year to compare against. I'd drop the column from the pack.”
Fix YoY Growth so it is 2025 revenue compared with the same period of 2024, as a fraction: (this year − last year) / last year. 2024 revenue is in the library measure [Revenue 2024], whose months are related to 'Date'[Date].
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