If you unpivot columns 'Q1', 'Q2', and 'Q3' in a sales table, what will the new columns be named by default?

medium📝 Formula Result Q5 of 15

Power BI - Data Cleaning with Power Query

A'Q' and 'Amount'

B'Quarter' and 'Sales'

C'Attribute' and 'Value'

D'Category' and 'Total'

Step-by-Step Solution

Solution:

Step 1: Recall default column names after unpivot
Power Query names the new columns 'Attribute' for original column names and 'Value' for their data.
Step 2: Check other options
Other names like 'Quarter' or 'Sales' are not default; they require manual renaming.
Final Answer:
'Attribute' and 'Value' -> Option C
Quick Check:
Default unpivot columns = Attribute and Value [OK]

Quick Trick: Default unpivot columns are 'Attribute' and 'Value' [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes