Forum Discussion

jjmauras's avatar
jjmauras
Advocate II
10 years ago
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 ...
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    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]"})

Fabiola_K's avatar
Fabiola_K
Advocate IV
10 years ago

I'm not an expert, but i've done in these cases is to create a third table with the
distinct values, and use it as a bridge between both tables.