A four-week Power Query practice plan
Guide · By Tahir Nas · Examples run in our simulator · Published · Updated
How each day works
- Read one lesson (5–10 minutes) and run its examples in your head before reading the result.
- Do the linked exercise in the simulator without hints first.
- If you needed a hint or the answer, add the exercise to Friday's review.
Week 1: import and tidy
Goal: turn a raw export into a typed, clean table. Lessons: applied steps, CSV import, banner rows, types, locale. Friday: the free Clean and summarise a sales export exercise end to end.
Week 2: columns, rows and text
Goal: shape tables on purpose. Choose vs remove columns, filters by value, sorting with tie-breakers, trimming and splitting text, replacing codes. Friday: redo any exercise you needed a hint for, without hints.
Week 3: combine and summarise
Goal: append, merge, group and reshape. Merge vs append, join kinds, composite keys, Group By with several aggregations, unpivot. Friday: predict the row count of a merge before running it, then check.
Week 4: robust and readable
Goal: queries that survive refresh and explain themselves. Errors and try … otherwise, folder combines, parameters, reading and writing M. Friday: a timed assessment.
A warm-up you can do on day one
Before the plan starts, read this query and predict the result. Then compare:
let
Orders = #table({"OrderID", "Status", "Qty"}, {{"A-1", "Complete", 2}, {"A-2", "cancelled", 5}, {"A-3", "Complete", null}, {"A-4", "Cancelled", 1}}),
Kept = Table.SelectRows(Orders, each [Status] <> "Cancelled")
in
Table.RowCount(Kept)Result
3
Output produced by the Power Query Exercises simulator, an independent implementation of a documented subset of M.
Practise it in the simulator
Each task opens the exact exercise in the browser workspace and is checked against fresh data, not just the example. Free tasks need no account.
- beginner~10 minFree
Clean and summarize a sales export
Trim messy region names, keep valid completed orders, remove an exact duplicate and total revenue by region.
- beginner~5 minFree
Keep only completed orders (kite shop)
Filter out cancelled and pending orders so only completed sales remain.
- beginner~7 minFree
Skip the title rows in a report export (consultancy)
The export starts with a report title and a blank line. Skip them, then promote the real headers.
- beginner~8 minFree
Reorder steps so cleaning happens before grouping (kite shop)
The query groups regions before cleaning them, so " north" and "North" are counted separately. Fix the step order.
Related pages
Lessons
Sources
Microsoft's official documentation for the features and functions used on this page.
- What is Power Query? (Concept, Microsoft Learn)
- Understanding Power Query M functions (Concept, Microsoft Learn)
- Best practices when working with Power Query (Concept, Microsoft Learn)
- Table.SelectRows (Function reference, Microsoft Learn)
- Table.RowCount (Function reference, Microsoft Learn)
Power Query Exercises is an independent educational platform and is not affiliated with, endorsed by, sponsored by, or approved by Microsoft Corporation. All third-party trademarks belong to their respective owners.