Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
MIN and MAX. MAX(table[column]) returns the largest value the cell can see and MIN the smallest. They work on numbers, dates and text, and they ignore every other row: one huge line decides the result on its own.
Cheapest Product = MIN(products[list_price])
Each regional warehouse is ordering pallets and needs to know the biggest single order line it has had to pack.
Write the measure Largest Line on order_items: the highest quantity on any one order line. The matrix shows it by region, filtered to completed orders.
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