Only Show Duplicates

[kattlees]

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             2/1/18                     2/3/18            887799

5423160       Sue Smith            2/5/18                     2/5/18            887799

654321        Jill Jones              3/8/18                     3/12/18          998877

759845        Bill Bradly             2/8/18                    2/8/18             665577

I would only want the two Sue Smith rows to show up. Possiblity there could be 3 or 4 entries for the same person so would need all of them to show up.

[Anonymous]

Doesn't the semi-colon vs comma issue have to do with the language setup of your computer?

[qamarulhassan]

@Vvelarde  Thanks for the solution. I was looking for this solution and it helps me. 😊

[Vvelarde · Accepted solution]

@kattlees

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

[GreggPowell]

Solution DOES NOT WORK> can't use semi-colons. Only Commas. Also, get an error on the 

EARLIER ( Table1[GUEST] )

Piece.

[CynicalWilson]

Maybe ease up on the intensity/outrage of your reply a bit? I'd really hate to see people being discouraged from participating due to getting yelled at if they make a mistake. 

[gidster99]

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

Thanks