Solved: Identify duplicates and show up records - Page 3

Anonymous · ‎07-11-2017

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.

Anonymous · ‎07-11-2017

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.

Identify duplicates and show up records