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

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

6 Replies

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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