Need calculating column like If the duplicates records in the column then Processed else new

[Venkateswara_ra]

If the record exists more than one time in the column then that record is processed or else new 

I need calculated column like type 

id type

2   Processed

2   Processed

4   New

5   New

6   Processed

6   Processed

6   Processed

7   New

[harshnathani · Accepted solution]

Hi @Venkateswara_ra ,

Create a Calculated Column

Type1 =

var a = CALCULATE(COUNT('Table'[id]), ALLEXCEPT('Table','Table'[id]))

RETURN

IF(a=1,"New","Processed")

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Venkateswara_ra]

Thanks Harsh Nathani