Forum Discussion

Post Patron

8 years ago

Solved

Only Show Duplicates

If I have this data - how do I get a table that will only SHOW Duplicates Guest ID Guest Start Date End Date MRNumber 123456 Sue Smith ...

Community Champion

8 years ago

Hi, you can use this calculated column to Mark the duplicates.

Duplicate =
IF (
    COUNTROWS ( FILTER ( Table1; Table1[GUEST] = EARLIER ( Table1[GUEST] ) ) )
        > 1;
    "YES";
    "NO"
)

The next Step will be apply a filter in the visual.

Regards

Victor

Frequent Visitor

7 years ago

Note: This only worked for me when I used commas and not semi-colons.

Thanks