Forum Discussion

kellyylx's avatar
kellyylx
Helper I
1 year ago
Solved

Identify duplicates

Hi, I have this unsorted table  contact name last activity > 2 years ago Adam TRUE Olivia FALSE Pauline FALSE Clarice TRUE Dominic  FALSE Ruby FALSE Olivia TRUE Ru...
  • rajendraongole1's avatar
    1 year ago

    Hi kellyylx - Create a New Calculated Column: Add a DAX calculated column to your table to check whether any record for each contact name has last activity > 2 years ago set to TRUE.

    replace with your model table name use below logic:

    calculated column:

    FlagHasTrue =
    CALCULATE(
    MAX('YourTableName'[last activity > 2 years ago]),
    ALLEXCEPT('YourTableName', 'YourTableName'[contact name])
    )

    Now, create a table or matrix visual where you can apply a filter on this new FlagHasTrue column. Set the filter condition to show rows where FlagHasTrue = TRUE. This will retain all rows of the contact names that have at least one record with "last activity > 2 years ago" as TRUE.

    Hope this helps.