Forum Discussion
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
olgad
Resident Rockstar
Resident RockstarHI, group by by column 1
expand All
and you will see the count. if greater than 1 than there is a duplicate
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.....