Forum Discussion

kattlees's avatar
kattlees
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          ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    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

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

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's avatar
GreggPowell
Helper I
4 years ago

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

EARLIER ( Table1[GUEST] )

Piece.


  • CynicalWilson's avatar
    CynicalWilson
    New Member
    4 years ago

    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.