Power QueryExercises

Functions and each quiz

each, underscore, custom functions and parameters.

Revise first: Write and use custom functions, Row context: whole-table values and the previous row, Raise and handle errors in your own functions, Scope, closures and List.Accumulate

Question 1

1.What does this return?

let f = (x) => x * 2 in f(21)
Question 2

2.What does this return?

List.Transform({1, 2, 3}, each _ + 1)
Question 3

3.What does this return?

let f = (a, optional b) => if b = null then a else a + b in f(5)
Question 4

4.Inside Table.AddColumn(T, "X", each [Qty] * 2), what is _?

Question 5

5.Inside Table.TransformColumns(T, {{"Name", each Text.Upper(_)}}), what is _?

Question 6

6.Why define a business rule as a named function?

Question 7

7.What does this return?

let Ship = (q as number) as number => if q >= 6 then 0 else 5 in Ship(6)
Question 8

8.What does this return?

List.Select({1, 2, 3, 4}, each Number.IsEven(_))
0 of 8 answered. Unanswered questions count as wrong.