Forum Discussion
Identify duplicates and show up records
I've got contact table with columns: names, emails. I want to identify duplicates in emails and show up their names. for example, show me the table like this. any ideas, thanks.
You could create a calculated column with the following formula:
Count Emails = Var Emails = [Emails] RETURN CALCULATE( COUNTROWS('Your Table'), all('Your Table'), 'Your Table'[Emails] = Emails )From here, you could simply look for any rows where the Count Emails is greater than 1.
Works perfectly