Power QueryExercises

Module 4

Working with columns

Choose, remove, rename, reorder and duplicate columns, and keep queries stable when columns change.

You'll be able to

Lessons

  1. 1.Choose Columns vs Remove ColumnsPick the column step that matches your intent so the query stays correct when the source schema changes.
  2. 2.Rename and reorder columnsProduce report-ready column names and order without changing any values.
  3. 3.Duplicate and combine columnsKeep raw values for auditing while producing derived columns.
  4. 4.When a column goes missing: MissingField optionsHandle optional and missing columns deliberately instead of hiding schema problems.

Take the working with columns quiz (8 questions)

Exercises