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]"})
Thanks everyone. Greg_Deckler I think I'm going to go with this solution for the moment as it worked right away. My question is will it stick? For example is it a one time thing or will it remove duplicates every time the SQL data is refreshed?
jjmauras Best practice would be to handle this at the source. Per Anonymous solution.