Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
VAR and RETURN. VAR gives a value a name inside a measure, and RETURN gives the result. Each variable is worked out once, in the filter context of the cell, so a formula that uses a figure twice reads (and runs) more simply. Brackets are not needed around a variable: it is already one value.
Avg Order Units = VAR U = [Units] VAR N = [Orders] RETURN DIVIDE(U, N)
Grace Whitfield wants each region's growth on last year next to the two revenue figures, as a share: 0.06 means 6% up on 2024.
Write the measure YoY Growth on order_items: ([Revenue] minus [Revenue 2024]) divided by [Revenue 2024]. Store each figure in a variable first. The matrix shows it by region next to both revenues.
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