Forum Discussion

Blizzard's avatar
Blizzard
Regular Visitor
8 years ago
Solved

How to count duplicate values only once in a column

Hi all,   I want to identify in a column (not as a measure) all values for a specific ID only once.    ID Date Unique 10 09.11.2017 YES 2 01.12.2017 YES 10 11.11.2011 NO  ...
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Blizzard

     

    Hi, try with this calculated column

     

    Unique =
IF (
    CALCULATE (
        MAX ( Table1[Date] );
        FILTER ( Table1; Table1[ID] = EARLIER ( Table1[ID] ) )
    )
        = Table1[Date];
    "Yes";
    "No"
)

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

Blizzard

 

Hi, try with this calculated column

 

Unique =
IF (
    CALCULATE (
        MAX ( Table1[Date] );
        FILTER ( Table1; Table1[ID] = EARLIER ( Table1[ID] ) )
    )
        = Table1[Date];
    "Yes";
    "No"
)

Regards

 

Victor

Lima - Peru

Blizzard's avatar
Blizzard
Regular Visitor
8 years ago

Vvelarde

 

Hi Victor,

 

your solution worked perfect. I had to change the initial idea from the latest to the earliest date, but that was easy with your solution!

 

Thanks a lot,

 

Michael