Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
IF in a calculated column. IF(condition, result_if_true, result_if_false) picks one of two values for each row. In a calculated column it turns a number or a date into a label you can group by. RELATED lets the condition use a column from the table on the one side of a relationship.
Big Order Line = IF(order_items[quantity] >= 10, "Big", "Small")
Operations pays for a weekend support shift and wants to know how much business actually comes in on Saturdays and Sundays.
Add the calculated column Day Type to orders: "Weekend" when the order was placed on a Saturday or Sunday, otherwise "Weekday". 'Date'[Weekday Number] runs from 1 for Monday to 7 for Sunday, and orders are related to 'Date' by order_date. The matrix shows Orders and Revenue by Day Type.
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