Power QueryExercises

Prepare for a Power Query practical test or analyst interview

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

Jump to the practice tasks

What tests usually contain

Task typeWhat's being checkedPractise with
Clean an exportTypes, trimming, removing junk rows, cultureClean a sales export (free)
Combine sourcesAppend vs merge, keys, unmatched rowsMerge and anti-join tasks
SummariseGroup By grain, correct aggregation, sortRegion summary task
Fix a broken queryReading M, finding the failing stepFix-the-step tasks
ExplainClear reasoning, checks, M vs DAX boundariesThe interview question bank

A 60-minute practice routine

  1. 5 min: read the brief twice. Write down the output grain (one row per what?) and the measures.
  2. 10 min: inspect the data. Headers, types, blanks, odd values, duplicates. Note them.
  3. 30 min: build the query in the order import → types → clean → filter → combine → summarise → sort.
  4. 10 min: verify. Control totals, row counts, unmatched keys.
  5. 5 min: write three sentences explaining the approach and one trade-off.

Always finish with a check

The single habit that separates strong candidates is showing that the answer is right. A two-line reconciliation is enough:

let
    Raw = #table({"OrderID", "Status", "Amount"}, {{"A-1", "Complete", 20}, {"A-2", "Cancelled", 35}, {"A-3", "Complete", 12}, {"A-3", "Complete", 12}}),
    Deduped = Table.Distinct(Raw),
    Complete = Table.SelectRows(Deduped, each [Status] = "Complete")
in
    #table({"Check", "Value"}, {
        {"Raw rows", Table.RowCount(Raw)},
        {"Exact duplicates removed", Table.RowCount(Raw) - Table.RowCount(Deduped)},
        {"Cancelled rows excluded", Table.RowCount(Deduped) - Table.RowCount(Complete)},
        {"Completed amount", List.Sum(Complete[Amount])}
    })

Result

CheckValue
Raw rows4
Exact duplicates removed1
Cancelled rows excluded1
Completed amount32

Output produced by the Power Query Exercises simulator, an independent implementation of a documented subset of M.

Every row is accounted for: 4 raw = 1 duplicate + 1 cancelled + 2 kept.

Explaining your work

Use five parts: goal, data issues, steps, checks, trade-offs. Say why the order matters where it does (clean before grouping, filter before ranking). If a question touches the report layer, say where you'd use DAX instead; see M vs DAX.

Honesty beats bluffing

If you haven't used a feature (gateways, folding against a real database), say so and describe what you'd check. Never describe work experience you don't have. The timed assessments on this site are self-assessment practice under time pressure, not a hiring credential.

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.