Power QueryExercises

A four-week Power Query practice plan

Guide · By Tahir Nas · Examples run in our simulator · Published · Updated

Jump to the practice tasks

How each day works

  1. Read one lesson (5–10 minutes) and run its examples in your head before reading the result.
  2. Do the linked exercise in the simulator without hints first.
  3. 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.

Three, not two: "cancelled" in lower case isn't equal to "Cancelled". If you predicted that, week 2 will feel easy.

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.

Lessons

More resources

Sources

Microsoft's official documentation for the features and functions used on this page.

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.