Power BI - Data Cleaning with Power Query
Which of the following is the correct syntax to remove duplicate rows from a table named
Sales in Power Query?Which of the following is the correct syntax to remove duplicate rows from a table named Sales in Power Query?
easy📝 Formula Fix Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall Power Query function for duplicates
The correct function to remove duplicates isTable.Distinct.Step 2: Apply function to the table
UsingTable.Distinct(Sales)removes duplicate rows from theSalestable.Final Answer:
Table.Distinct(Sales) -> Option CQuick Check:
Table.Distinct = Remove duplicates [OK]
Quick Trick: Use Table.Distinct to remove duplicates in Power Query [OK]
Common Mistakes:
- Using non-existent functions like Remove.Duplicates
- Confusing syntax with other languages
- Adding extra parameters unnecessarily
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