Power QueryExercises

Fill down and report layouts quiz

Fill down/up and cleaning report-style exports.

Revise first: Fill down and tidy report layouts, Fill up, and gaps that aren't null, Turn section headings into a column, Combine two header rows into column names

Question 1

1.What does this return?

Table.FillDown(#table({"R", "S"}, {{"N", 1}, {null, 2}, {"S", 3}, {null, 4}}), {"R"})[R]
Question 2

2.What does this return?

Table.FillUp(#table({"R"}, {{null}, {"X"}}), {"R"})[R]
Question 3

3.Does Fill Down replace empty text ("")?

Question 4

4.Where should Fill Down go relative to sorting?

Question 5

5.How should you remove Subtotal rows?

Question 6

6.Why remove pre-calculated totals from imported data?

Question 7

7.How many rows remain?

Table.RowCount(Table.SelectRows(#table({"Store"}, {{"A"}, {"Subtotal"}, {"B"}, {"Grand Total"}}), each [Store] <> "Subtotal" and [Store] <> "Grand Total"))
Question 8

8.A report prints the group name on its total line, after its rows. Which fill fits?

0 of 8 answered. Unanswered questions count as wrong.