Power QueryExercises

Move the key column first and keep the rest in order (it assets)

Put AssetID first. Every other column keeps its current order, including columns added in future exports.

Level
intermediate
Time
~7 min
Task
Build the query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Reorder columns with a list computed from the table, so new columns aren't dropped or misplaced.

Quillstack (fictional) keeps an IT asset register exported from its device-management tool, which puts the asset ID in the middle.

Steps

  1. Move AssetID to be the first column.
  2. Every other column stays in its current relative order. Future exports may add columns; keep them too.
  3. Column order is graded.

Your result must

  • AssetID is first
  • Other columns keep their order
  • New columns are kept

Input

  • Assets (table)
    • Type: text
    • Purchased: text
    • AssetID: text
    • Owner: text
    • Model: text

Expected output columns

AssetID (text), Type (text), Purchased (text), Owner (text), Model (text)

First 3 of 4 expected rows
AssetIDTypePurchasedOwnerModel
A-1Typ-70Pur-48Own-81Mod-44
A-2Typ-18Pur-96Own-65Mod-35
A-3Typ-49Pur-68Own-96Mod-75