Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Thresholds in the column's units. A band's thresholds must be written in the same units as the column. A share stored as a fraction (a half is 0.5) never reaches a threshold written as a percent (50), so the top band silently stays empty. Look at a few values of the column before you write the tests.
Cost Share = SWITCH(TRUE(), products[unit_cost] / products[list_price] < 0.45, "Low", "High")
Finance thinks deep discounts are giving away too much. Before changing the policy, they want units and revenue split by how deep each order line was discounted.
Add the calculated column Discount Band to order_items: "Deep" for a discount of 10% or more, "Light" for any smaller discount, and "None" for lines with no discount. The matrix shows Units and Revenue by Discount Band.
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