Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Return the last value with specific conditions

Not sure really how to title this one   I have a table that i want to add a calculated column to, to give me a Gold/Silver/Bronze category (already created) by the store ID. So in the image below, ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this calculated column formula

     

    =IF(Data[Date]=CALCULATE(MAX(Data[Date]),FILTER(Data,Data[ID]=EARLIER(Data[Date])&&Data[CycleName]=EARLIER(Data[CycleName]))),Data[GSB],BLANK())

     

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Perfect thanks Ashish_Mathur

Slight error as it should be ID=EARLIER(ID) which I amended and now all is working

 

Thanks :)

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

You are welcome.