Power QueryExercises

Module 5

Filtering and sorting rows

Filter by value, combine conditions, sort on several keys and keep top or bottom rows.

You'll be able to

Lessons

  1. 1.Filter rows by valueWrite filters that describe the rows you want, so they keep working when the data changes.
  2. 2.Sort rows on more than one columnSort on several keys in one step and know when order is meaningful for the output.
  3. 3.Keep the top N rows after sortingRank rows by a calculated value and keep the top N in a refresh-safe way.
  4. 4.Remove blank rows and keep an explicit row orderDrop empty rows safely and keep a reliable record of source order.

Take the filtering and sorting rows quiz (8 questions)

Exercises