Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Matching keys. LOOKUPVALUE compares the search column with the value you pass, one value at a time. If you pass a different kind of ID, most rows find no match and return blank, and the few accidental matches are wrong. Always pass the column that holds the same IDs as the search column.
Region Name = LOOKUPVALUE(regions[region], regions[region_id], customers[region_id])
Finance asked for the cost of goods sold by customer segment. products isn't connected to order_items in this copy of the model, so the AI assistant used LOOKUPVALUE. The costs it reports are tiny next to revenue.
AI assistant: “Cost of Goods is ready. Costs are well under 1% of revenue in every segment, so Brightline's margins are excellent.”
Fix Cost of Goods so each completed order line's quantity is multiplied by the unit_cost of its own product, added up by segment.
Matrix
Updates as you typeFilters on this visualorders[status] is completed
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe