Power QueryExercises

Find the three largest orders (kite shop)

Calculate each order's value and keep the three biggest, largest first.

Level
intermediate
Time
~8 min
Task
Build the query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Combine a calculated column, a descending sort and Keep Top Rows.

Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.

Steps

  1. Add Value = Qty × UnitPrice.
  2. Sort by Value descending and keep the top 3 rows.
  3. Output only OrderID, Customer and Value.

Your result must

  • Exactly 3 rows
  • Largest value first
  • Columns: OrderID, Customer, Value

Input

  • Orders (table)
    • OrderID: text
    • Customer: text
    • Region: text
    • Product: text
    • Qty: number
    • UnitPrice: number
    • OrderDate: text
    • Status: text

Expected output columns

OrderID (text), Customer (text), Value (number)

First 3 of 3 expected rows
OrderIDCustomerValue
0009Zane Brandt502.56000000000006
0007Nia Yilmaz188.37
0006Yara Silva158.04