[Solved] You used this M code to pivot a column:Table.Pivot(Source, List.Distinct(Source[Type]), "Type", "Value")but it returns an error. What is the most probable reason? | Power BI

Power BI - Data Cleaning with Power Query

You used this M code to pivot a column:

Table.Pivot(Source, List.Distinct(Source[Type]), "Type", "Value")

but it returns an error. What is the most probable reason?

AThere are duplicate values in the pivot column without specifying an aggregation function

BThe source table is empty

CThe column names are case-sensitive and mismatched

DList.Distinct is not a valid function in Power Query

Step-by-Step Solution

Solution:

Step 1: Identify duplicates in pivot column
Check if the 'Type' column has duplicate entries for the same row context.
Step 2: Understand pivot requirements
Pivoting requires unique keys or an aggregation function to handle duplicates.
Final Answer:
There are duplicate values in the pivot column without specifying an aggregation function -> Option A
Quick Check:
Duplicates without aggregation cause errors [OK]

Quick Trick: Duplicates need aggregation when pivoting [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

You used this M code to pivot a column: