Mark records that appeared the first time in a table as "New" based on date, if exists mark as "Old"

[ma142]

Hello,

I need help how to mark records that appeared the first time in a table as "New" based on date, if exists mark as "Renew".

Column Status is my desired output.

[ma142]

Thank you Ashish, it worked perfectly.

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Write this calculated column formula

Status = if(Data[Date]=calculate(min(Data[Date]),filter(Data,Data[Emp I.D]=earlier(Data[Emp I.D]))),"New","Old")

Hope this helps.