Power Query practice: Custom M Functions & Reusable Logic
Chapter 18 · 5 questions · included in full access
Question 1 · hard
Your own function
Solve it in your browserIn the Advanced Editor, define
WithGST = (amount) => amount * 1.18,as a step, then add a custom column Gross =WithGST([Qty] * [UnitPrice]).Question 2 · easy
Custom function rocket arrow syntax
Solve it in your browserIn the M formula language, what does the
=>operator indicate?Question 3 · medium
Reusable GST tax calculation
Solve it in your browserIn raw M: define
Tax = (p as number) as number => p * 0.18, then add column TaxAmount usingTable.AddColumn.Question 4 · hard
Multi-argument custom function
Solve it in your browserDefine
Net = (qty as number, price as number) as number => qty * price * 0.9, and add column NetTotal usingTable.AddColumn.Question 5 · medium
List transformation iterators
Solve it in your browserWhat is the primary benefit of using
List.Transformin Power Query M?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing