AnalystReps

Power Query practice: Pivoting & Unpivoting Data

Chapter 15 · 5 questions · included in full access

  1. Question 1 · medium

    Unpivot Other vs Unpivot Selected

    Next year TargetsWide gains an Apr column. Which choice keeps working without edits?

    Solve it in your browser

  2. Question 2 · medium

    Unpivot monthly targets

    Turn TargetsWide into one row per rep per month. Select Rep, right-click ▸ Unpivot Other Columns, then rename Attribute → Month and Value → Target.

    Solve it in your browser

  3. Question 3 · hard

    Pivot back to wide

    The data is already long (Rep, Month, Target). Pivot it back: select Month ▸ Transform ▸ Pivot Column, values column Target, aggregation Sum.

    Solve it in your browser

  4. Question 4 · easy

    The wide matrix reporting antipattern

    Why should wide presentation matrices (with months as columns) be unpivoted before loading into Power BI?

    Solve it in your browser

  5. Question 5 · medium

    Unpivot selected target months

    Unpivot only the Jan and Feb columns of TargetsWide using Table.Unpivot. Label attribute as "Month" and value as "Target".

    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