How to count duplicate values only once in a column

Question

Hi all,&nbsp;I want to identify in a column (not as a measure) all values for a specific ID only once.&nbsp;&nbsp;IDDateUnique1009.11.2017YES201.12.2017YES1011.11.2011NO&nbsp;The respective formular in Excel works fine as follows:&nbsp;=IF(MATCH(A4,A:A,0)=ROW(),"YES","NO")&nbsp;What I wanted to do is, that the last entry of an ID is identified as unique (column C) and all past values of the same ID should be marked as "no". Therefore the DISTINCTCOUNT formular with filter is not working. In that case, all double values would be counted &gt; 1. For ID 10 the outcoume would be 2 for both rows but I want to count ID excatly one time as unique.&nbsp;I dont want to delete duplicate rows.&nbsp;Does anyone has an idea how to solve that problem?&nbsp;RegardsMichael

vvelarde · Accepted Answer

Blizzard&nbsp;Hi, try with this calculated column&nbsp;Unique =
IF (
    CALCULATE (
        MAX ( Table1[Date] );
        FILTER ( Table1; Table1[ID] = EARLIER ( Table1[ID] ) )
    )
        = Table1[Date];
    "Yes";
    "No"
)Regards&nbsp;VictorLima - Peru

Forum Discussion

How to count duplicate values only once in a column

2 Replies

Related content

remove duplicate value within a row

Remove Duplicate Values in Column

Filter a column with duplicate values based on the highest Index value

Duplicate Value

Merge duplicates data in columns

ID	Date	Unique
10	09.11.2017	YES
2	01.12.2017	YES
10	11.11.2011	NO