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.

     

Portrek's avatar
Portrek
Icon for Resolver III rankResolver III
5 years ago


Hi Alexburn

You can create a custon column using the code below.

Max = CALCULATE(MAX(Table[Progress____]),ALLEXCEPT(Table,Table[Job______]))

 

Best regards.

alexburn's avatar
alexburn
New Member
5 years ago

This does not work because the latest date is not always the maximum progress.

Also, it is not checking the [Period] column for blanks to exclude those from the calculation.