Forum Discussion

jak8282's avatar
jak8282
Helper III
3 years ago
Solved

Get value against max date

Hi,

 

I have a table like follows

DateNameOutcome
21/09/2022bobfail
23/09/2022bobpass
24/09/2022bobfail
21/09/2022jennypass
   
   
   

 

I want to have a table which return the latest outcome

 

NameOutcome
bobFail
jennypass
  
  
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi jak8282 
    Please try this measure:

    Latest Outcome =
    VAR LatestDate = CALCULATE(
        MAX('Table'[Date]),
        ALLEXCEPT('Table', 'Table'[Name])
    )
    RETURN
    CALCULATE(
        VALUES('Table'[Outcome]),
        'Table'[Date] = LatestDate,
        'Table'[Name] = SELECTEDVALUE('Table'[Name])
    )

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly 



1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    Hi jak8282 
    Please try this measure:

    Latest Outcome =
    VAR LatestDate = CALCULATE(
        MAX('Table'[Date]),
        ALLEXCEPT('Table', 'Table'[Name])
    )
    RETURN
    CALCULATE(
        VALUES('Table'[Outcome]),
        'Table'[Date] = LatestDate,
        'Table'[Name] = SELECTEDVALUE('Table'[Name])
    )

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly