Power QueryExercises

Group by and aggregation quiz

Counting rows vs values, sums, averages and nested group operations.

Revise first: Group by with several aggregations, All Rows grouping and per-group calculations, Group by several keys and sort the output, Group consecutive rows with GroupKind.Local

Question 1

1.What does this return?

List.Sum({2, null, 3})
Question 2

2.What does this return?

List.Average({2, null, 4})
Question 3

3.How many distinct customers?

List.Count(List.Distinct({"Ana", "Bo", "Ana", "Cy"}))
Question 4

4.What does this return?

Table.SelectRows(Table.Group(#table({"R", "Q"}, {{"N", 2}, {"S", 1}, {"N", 3}}), {"R"}, {{"T", each List.Sum([Q])}}), each [R] = "N"){0}[T]
Question 5

5.Inside a Group By aggregation, what is [Qty]?

Question 6

6.Does Group By guarantee the order of the output rows?

Question 7

7.How do you rank claims within each employee?

Question 8

8.Count Rows vs count distinct values: which answers 'how many different customers ordered'?

0 of 8 answered. Unanswered questions count as wrong.