Bird
0
0

Which step correctly describes how to unpivot columns in Power Query Editor?

easy📝 data modeling Q12 of 15
Power BI - Data Cleaning with Power Query
Which step correctly describes how to unpivot columns in Power Query Editor?
ASelect the columns to unpivot, right-click, and choose 'Unpivot Columns'.
BSelect the columns, then click 'Merge Queries'.
CSelect the columns, then click 'Add Column' > 'Custom Column'.
DSelect the columns, then click 'Remove Columns'.
Step-by-Step Solution
Solution:

  1. Step 1: Identify the unpivot action in Power Query

    Unpivoting is done by selecting columns, right-clicking, and choosing 'Unpivot Columns'.

  2. Step 2: Differentiate from other options

    'Merge Queries' combines tables, 'Add Column' creates new columns, and 'Remove Columns' deletes columns, none unpivot data.

  3. Final Answer:

    Select the columns to unpivot, right-click, and choose 'Unpivot Columns'. -> Option A

  4. Quick Check:

    Unpivot = Right-click > Unpivot Columns [OK]
Quick Trick: Right-click selected columns and pick 'Unpivot Columns' [OK]
Common Mistakes:
  • Choosing 'Merge Queries' instead of unpivot
  • Trying to add a custom column to unpivot
  • Removing columns instead of unpivoting

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Why choosing the right visual matters - Quiz 6medium Basic Visualizations - Bar and column charts - Quiz 1easy Basic Visualizations - Map visualizations - Quiz 11easy Data Cleaning with Power Query - Pivoting columns - Quiz 10hard Data Cleaning with Power Query - Handling null and blank values - Quiz 4medium Formatting and Design - Visual formatting options - Quiz 15hard Formatting and Design - Why design improves report clarity - Quiz 2easy Getting Data - Multiple data sources in one report - Quiz 4medium Getting Data - OData and REST API connections - Quiz 1easy Power Query Editor - Sorting data - Quiz 4medium