Power QueryExercises

Replace sort-then-remove-duplicates with a deterministic rule (support plans)

The starter sorts newest first and removes duplicates to keep each account's latest status. Power Query doesn't guarantee which duplicate survives; make it explicit.

Level
advanced
Time
~11 min
Task
Fix a broken query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Rewrite a fragile 'latest record' pattern as grouping with Table.Max.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • Updates (table)
    • Account: text
    • Updated: text
    • Status: text

Expected output columns

Account (text), Updated (date), Status (text)