Check Values exist in same Table

[hitesh1607]

I have a table below - And I need a calculated column that gives me the information for Code A, whether the Id already exists or not in code B

ID	Code
100	A
102	A
103	A
100	B
101	B

So the final table should look like this:

ID	Code	Exist or Not?
100	A	Exist
102	A	New
103	A	New
100	B
101	B

[hitesh1607 · Accepted solution]

X =
VAR _1 =
    COUNTX (
        FILTER ( Table, [ID] = EARLIER ( [ID] ) && [Code] < EARLIER ( [Code] ) ),
        [ID]
    ) + 0
RETURN
    IF ( _1 > 0, "Old", "New" )