Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Identify Duplicates

How to check duplicate values in a column1, create new  adde column, if in case duplicate values present in the column1 display as well new added column 

 

 

 

Need Help

2 Replies

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    HI, group by by column 1

    expand All
    and you will see the count. if greater than 1 than there is a duplicate

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      With out grouping, Is there any alternativies to fing the duplicates ?like IF condition like this,,
      ex: i have tried somthing in statically : if ([Column1] <> "null") then Table.RowCount(Table.SelectRows(#"Changed Type5", each ([Column1] = "XXXXX"))) else ""
      but is there in any altenativies.....