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 Date table. A Date table has one row per day with handy columns like Year, Quarter and Month Name. Connect a fact table's date column to Date[Date] and every visual can slice that table by month or quarter. Each day appears once in Date, so Date is the one side.
targets[month] → 'Date'[Date]
Finance wants Revenue by month for 2025. The matrix is built on the Date table, but every month shows the full-year number.
Add the relationship that lets the Date table filter orders, so each month shows only the revenue of orders placed in that month.
Matrix
Updates as you typeFilters on this visual'Date'[Year] is 2025
Loading the Brightline model…
Language