Power QueryExercises

Module 13

Group by and aggregation

Summaries with sums, counts, averages and all-rows tables.

You'll be able to

Lessons

  1. 1.Group by with several aggregationsBuild summary tables with the right aggregation for each question.
  2. 2.All Rows grouping and per-group calculationsRun a calculation inside each group and bring the detail rows back.
  3. 3.Group by several keys and sort the outputChoose the grain of a summary table and present it in a deliberate order.
  4. 4.Group consecutive rows with GroupKind.LocalSummarise runs of consecutive values instead of all occurrences of a value.

Take the group by and aggregation quiz (8 questions)

Exercises