AnalystReps

Power Query practice: Appending Queries & Stacking Files

Chapter 13 · 5 questions · included in full access

  1. Question 1 · easy

    Append two months

    Stack SalesFeb under SalesJan: Home ▸ Append Queries, choose SalesFeb.

    Solve it in your browser

  2. Question 2 · medium

    Append three months

    Append SalesFeb and SalesMar to SalesJan in one step. March has an extra Discount column — see what happens to it.

    Solve it in your browser

  3. Question 3 · easy

    Schema alignment during append

    What happens in Power Query if you append two tables where one has column "Sales" and the other has "sales"?

    Solve it in your browser

  4. Question 4 · medium

    Add file provenance before combine

    Combine SalesJan and SalesFeb: add a Month column ("Jan" to SalesJan, "Feb" to SalesFeb), then combine with Table.Combine.

    Solve it in your browser

  5. Question 5 · hard

    Consolidated Q1 ledger

    Consolidate all three monthly tables (SalesJan, SalesFeb, SalesMar) using Table.Combine, then sort by Date ascending.

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing