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]"})
Anonymous, I ran into this issue in Power Query as well. I followed the problem in this article by Ken Puls, and it fixed the problem on the first shot.
Thanks I will take a look