cancel
Showing results for
Did you mean:
Regular Visitor

## Display duplicates on several columns

Hello everyone,

is there a way where i can display all duplicates on several columns?

Example:

 Name Address1 Address2 A BA CA AA BA CB AB BB CA AC BC CC AA BD CD AD BE CE AE BA CF AF BF CG

Expected Result:

 Name Address1 Address2 A BA CA AA BA CB AB BB CA AA BD CD AE BA CF

I want to show the columns with duplicates. Unique records were removed.

Is this possible? Many thanks!!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User

## Re: Display duplicates on several columns

@ogureisuo

You can use this calculated column to check for the Duplicates

```Check =
VAR Cond1 =
IF (
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Name] ) ) = 1,
1
)
VAR Cond2 =
IF (
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Address1] ) ) = 1,
1
)
VAR Cond3 =
IF (
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Address2] ) ) = 1,
1
)
RETURN
IF ( Cond1 = 1 && Cond2 = 1 && Cond3 = 1, BLANK (), "Duplicates" )
```
Super User

## Re: Display duplicates on several columns

@ogureisuo

Please see attached file as well

3 REPLIES 3
Super User

## Re: Display duplicates on several columns

@ogureisuo

You can use this calculated column to check for the Duplicates

```Check =
VAR Cond1 =
IF (
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Name] ) ) = 1,
1
)
VAR Cond2 =
IF (
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Address1] ) ) = 1,
1
)
VAR Cond3 =
IF (
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Address2] ) ) = 1,
1
)
RETURN
IF ( Cond1 = 1 && Cond2 = 1 && Cond3 = 1, BLANK (), "Duplicates" )
```
Super User

## Re: Display duplicates on several columns

@ogureisuo

Please see attached file as well

Regular Visitor

## Re: Display duplicates on several columns

Thank you so much! This helps!!!