You wrote Table.Distinct(Sales, "ProductID") to remove duplicates by ProductID but get an error. What is the likely problem?

medium📝 Formula Fix Q14 of 15

Power BI - Data Cleaning with Power Query

You wrote Table.Distinct(Sales, "ProductID") to remove duplicates by ProductID but get an error. What is the likely problem?

AThe second argument should be a list of column names, not a single string

BTable.Distinct does not accept a second argument

CProductID column does not exist in Sales table

DYou must use Table.RemoveDuplicates instead

Step-by-Step Solution

Solution:

Step 1: Check Table.Distinct syntax for columns
The second argument must be a list of column names, e.g., {"ProductID"}, not a string.
Step 2: Identify error cause
Passing "ProductID" as a string causes a syntax error because it expects a list.
Final Answer:
The second argument should be a list of column names, not a single string -> Option A
Quick Check:
Columns argument = List, not string [OK]

Quick Trick: Use curly braces {} for column list in Table.Distinct [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