Replace sort-then-remove-duplicates with a deterministic rule (subscriptions)
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)