AnalystReps

Power Query practice: Custom Columns & M Arithmetic

Chapter 10 · 5 questions · included in full access

  1. Question 1 · medium

    Joined label

    Add a custom column Label showing Region and Rep like North - Asha Verma.

    Solve it in your browser

  2. Question 2 · hard

    Text and numbers together

    Add Line showing e.g. ACP Sheet Silver x12 — the Product, a space, x, and the Qty.

    Solve it in your browser

  3. Question 3 · medium

    Build a code

    Add Code: the first 3 letters of Product, a dash, and the last 4 characters of OrderID (e.g. ACP-1001).

    Solve it in your browser

  4. Question 4 · easy

    Gross order revenue

    Add GrossRevenue: multiply Qty by UnitPrice using Table.AddColumn with Currency.Type.

    Solve it in your browser

  5. Question 5 · hard

    Safe margin percentage

    Add MarginPct: compute ([UnitPrice] - 2000) / [UnitPrice] rounded to 2 decimal places using Number.Round. Guard against zero UnitPrice.

    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.

See pricing