Need a conditional Logic to label based on Dimension

[Sarath5c8]

In the below mentioned screenshot, desired output is the label which is condition if within Product if the Status is changed from Null (thats the initial status which will be assigned) to a string P1 and its create date is 4/8/22 that means if within product if the status changes from Null to any value it should be Labelled "New" , else if with Product if it changes from some value P1 to P12 then it should be labelled "Existing".

           

[Ashish_Mathur · Accepted solution]

Hi,

Write this calculated column formula.  For Bench (status JOU14), the result should be New because the status as on the previous date was Null.

Label = if(Data[Status]="Null",BLANK(),if(lookupvalue(Data[Status],Data[Date],CALCULATE(MAX(Data[Date]),FILTER(Data,Data[Product]=EARLIER(Data[Product])&&Data[Date]<EARLIER(Data[Date]))),Data[Product],Data[Product])="Null","New","Existing"))

Hope this helps.

[Sarath5c8]

@amitchandak or @johnt75 can you help