Power Query practice: Numeric Operations, Rounding & Statistics

Chapter 8 · 5 questions · included in full access

Question 1 · easy
Revenue column
Add a column Revenue = Qty × UnitPrice. Use Add Column ▸ Custom Column and the formula [Qty] * [UnitPrice].
Solve it in your browser
Question 2 · hard
Share of total
Add Share = each order's Qty divided by the total Qty of all orders, rounded to 3 decimals. Reference the whole column as Source[Qty].
Solve it in your browser
Question 3 · easy
Integer division vs standard division
In Power Query M, what does Number.IntegerDivide(14, 4) return?
Solve it in your browser
Question 4 · medium
Round unit pricing
Add DiscountedPrice: multiply UnitPrice by 0.93 and round to 2 decimal places using Number.Round.
Solve it in your browser
Question 5 · medium
Target variance magnitude
Add Variance: calculate the absolute difference between Target and 70000 using Number.Abs.
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.

Revenue column