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

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?