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

qamarulhassan's avatar
qamarulhassan
Regular Visitor
5 years ago

Vvelarde  Thanks for the solution. I was looking for this solution and it helps me. ðŸ˜Š