Forum Discussion

alexburn's avatar
alexburn
New Member
5 years ago
Solved

Latest value after filters

Hi guys,   Here is an example of my raw data:   Job______ Period___ Date______________ Progress____ 11111 N1 01 May 2021 50 11111 N2 01 June 2021 60 11111   01 July 2021 0...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This calculated column fomula works

    =LOOKUPVALUE(Data[Progress____],Data[Date______________],CALCULATE(MAX(Data[Date______________]),FILTER(Data,Data[Job______]=EARLIER(Data[Job______])&&Data[Period___]<>BLANK())),Data[Job______],Data[Job______])

    Hope this helps.

     

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

Hi,

This calculated column fomula works

=LOOKUPVALUE(Data[Progress____],Data[Date______________],CALCULATE(MAX(Data[Date______________]),FILTER(Data,Data[Job______]=EARLIER(Data[Job______])&&Data[Period___]<>BLANK())),Data[Job______],Data[Job______])

Hope this helps.

 

  • alexburn's avatar
    alexburn
    New Member
    5 years ago

    Thank you, this worked perfectly!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      You are welcome.