Power BI - Data Cleaning with Power Query
Why does Power Query create 'Attribute' and 'Value' columns after unpivoting instead of keeping original column names?
Why does Power Query create 'Attribute' and 'Value' columns after unpivoting instead of keeping original column names?
hard📝 Conceptual Q10 of 15
Step-by-Step Solution
Solution:
Step 1: Understand unpivoting output
Unpivoting converts multiple columns into two columns: one for original column names ('Attribute') and one for values ('Value').Step 2: Reason why this structure is used
This standard structure makes filtering, grouping, and analysis easier in Power BI.Final Answer:
To standardize data structure for easier filtering and analysis -> Option BQuick Check:
Unpivot creates standard columns for analysis [OK]
Quick Trick: Attribute and Value columns standardize data for analysis [OK]
Common Mistakes:
- Thinking original names are lost permanently
- Believing unpivot reduces rows (it increases rows)
- Assuming unpivot creates calculated columns
Master "Data Cleaning with Power Query" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes