Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
Thank you Ashish, it worked perfectly.
You are welcome.
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.