Power QueryExercises

Module 9

Duplicates and keys

Remove duplicates deliberately, choose the right row to keep and add index columns.

You'll be able to

Lessons

  1. 1.Remove duplicates on the right keyDeduplicate by business key and control which row survives.
  2. 2.Add index columnsNumber rows meaningfully by sorting first and choosing the start value.
  3. 3.Check key quality before you rely on itProve a key is unique and non-null, and list the offending values when it isn't.
  4. 4.Choose which duplicate to keep with a business ruleImplement a multi-criteria survivor rule that gives the same answer on every refresh.

Take the duplicates and keys quiz (8 questions)

Exercises