Power Query practice: The M Formula Language Anatomy

Chapter 17 · 5 questions · included in full access

Question 1 · easy
Write a step by hand
Open Advanced Editor and add a step that keeps only West orders. Type it yourself: add a comma after the Source line, then

#"Filtered Rows" = Table.SelectRows(Source, each [Region] = "West")

and change the last line after in to #"Filtered Rows".
Solve it in your browser
Question 2 · easy
What does "in" do?
In a query's let … in … block, what does the expression after in decide?
Solve it in your browser
Question 3 · medium
each, decoded
each [Qty] * 2 is shorthand for which function?
Solve it in your browser
Question 4 · easy
Helper queries
A query is only used as an input to other queries. How should you load it?
Solve it in your browser
Question 5 · medium
Step chaining in M
In raw M: take Orders, remove Notes with Table.RemoveColumns, then filter Qty > 20 with Table.SelectRows. Return the filtered step in in.
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

Write a step by hand