Identify the oldest record

[KH_Mike]

Hi All,

I have a set of data like this. For the ID, they have duplication under different "Record Date". What I want to do is to create a new column to check if the "ID" have duplication, it will show "Y" for the oldest record and "N" for the remaining. For the "ID" without duplication, it will always show "Y". Thank you.

ID	Record Date	Expected Result
A	2022-06	Y
A	2022-07	N
A	2022-08	N
B	2022-07	Y
C	2022-06	Y
D	2022-06	Y
B	2022-08	N

[PVO3 · Accepted solution]

Hello,

Try this

Column =

VAR _0 = 'Table'[ID]

VAR _1 = CALCULATE(MIN('Table'[Record Date]), FILTER('Table',('Table'[ID] = _0)))

RETURN

IF(

    'Table'[Record Date] = _1,

    "Y",

    "N"

)