Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Sales operations asked the AI assistant for completed orders year to date, next to each month's orders. In its matrix the two columns are identical in every month.
AI assistant: “Orders YTD is in the matrix. It matches Orders month by month, which shows the running total is consistent with the monthly figures.”
Fix Orders YTD so each month shows the completed orders from January 1 up to the end of that month. Time intelligence in this model runs on the Date table's '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