Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Calculated columns. A calculated column adds a value to every row of a table, worked out from that row's other columns. Unlike a measure, it is stored in the model, so you can put it on rows, in a slicer or in a filter. Use one when you need to group or filter by something the data doesn't have yet.
Order Month = MONTH(orders[order_date])
Marketing wants to know whether the customers who joined in 2025 already pull their weight. customers has a signup_date, but a matrix can't group a date column by year on its own.
Add the calculated column Signup Year to customers: the year of each customer's signup_date. The matrix shows Revenue and Orders by Signup Year.
Matrix
Updates as you typeLoading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe