Power QueryExercises

Sort tickets by business priority, not alphabetically (telecom)

Sort Urgent, High, Medium, Low (in that order), then oldest first within each priority.

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

Sort by a custom order using a rank from a list.

Lumen Mobile (fictional) logs customer support tickets and exports them for the weekly operations review.

Steps

  1. Sort tickets by Priority in the order Urgent, High, Medium, Low.
  2. Within the same priority, sort by Opened ascending (yyyy-mm-dd text sorts correctly), then by TicketID ascending.
  3. Keep exactly the original columns (no helper column in the result). Row order is graded.

Your result must

  • Urgent tickets first, Low last
  • Oldest first within a priority
  • No extra columns

Input

  • Tickets (table)
    • TicketID: text
    • Opened: text
    • Closed: text (nullable)
    • Priority: text
    • Channel: text
    • Agent: text
    • Topic: text

Expected output columns

TicketID (text), Opened (text), Closed (text (some rows null)), Priority (text), Channel (text), Agent (text), Topic (text)

First 3 of 9 expected rows
TicketIDOpenedClosedPriorityChannelAgentTopic
T10042026-02-172026-02-19UrgentEmailKalaniBilling
T10002026-04-07nullUrgentPhoneLenaUpgrade
T10062026-03-072026-03-10MediumEmailKalaniRouter