When pivoting columns in Power BI, why must you provide an aggregation function if there are multiple values for the same pivot key?

hard📝 Conceptual Q10 of 15

Power BI - Data Cleaning with Power Query

ABecause the pivot operation automatically removes duplicates without aggregation

BBecause pivoting only works with numeric columns

CBecause Power BI cannot handle text values in pivot columns

DBecause Power BI needs a way to combine multiple values into a single cell

Step-by-Step Solution

Solution:

Step 1: Understand pivot mechanics
Pivoting transforms rows into columns, but if multiple rows map to the same pivot key, multiple values exist.
Step 2: Role of aggregation
An aggregation function (like sum, average) combines these multiple values into one cell.
Final Answer:
Because Power BI needs a way to combine multiple values into a single cell -> Option D
Quick Check:
Aggregation merges duplicates in pivoted columns [OK]

Quick Trick: Aggregation merges multiple values per pivot key [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