Forum Discussion
Solved
Remove or Hide Duplicate Values
Is there a way to Remove or Ignore duplicate values when they occur in a column? I'm pulling data from our SQL Server. I have 2 related tables. Every once in a while a duplicate value will occur ...
There is a Remove Duplicates step when editing your query, it is in the Reduce Rows section of the ribbon, the M code is:
#"Removed Duplicates" = Table.Distinct(#"[Previous Step]", {"[Column Name]"})
jjmauras You can handle this in SQL with a CTE or subquery using the row_number() function. This will handle everything automatically.