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

  • gidster99's avatar
    gidster99
    Frequent Visitor
    7 years ago

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

    Thanks

  • 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.