Power QueryExercises

Sort orders by region, then by price (kite shop)

Produce a list sorted by Region A→Z and, within each region, by UnitPrice from highest to lowest.

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

About this exercise

What you'll practise

Sort on more than one column and understand that the first sort key wins.

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

Steps

  1. Sort by Region ascending.
  2. Within each region, sort by UnitPrice descending.
  3. Keep all rows and columns.

Your result must

  • Rows are in Region order A→Z
  • Within a region, highest UnitPrice first
  • Row order is checked for this task

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), Region (text), Product (text), Qty (number), UnitPrice (number), OrderDate (text), Status (text)

First 3 of 10 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatus
0004Jun UddinEastTail Ribbon134.382026-05-23Complete
0006Priya GrieveNorthTail Ribbon546.772026-05-02Complete
0009Farah QuistNorthBox Kite839.282026-06-02Complete