How to get a string based on the latest date using DAX

[jonclay]

Hi everyone

I'm trying to retireve a string of text (in this case it's called destination) based on the latest transactiondate.

I'm using the following DAX measure but it's not working for me:

Latest_Destination =

MAXX (

    FILTER (

        transaction,

        transaction[transactiondate]

    ),

    transaction[destination]

)

What I'm currently getting appears to be the desination of the earliest transactiodate not the latest, but I can't work out why!

Any help would be much appreciated.

Many thanks
Jon

[jonclay]

Hi @miTutorials 

Thank you so much, that works perfectly.

Best wishes
Jon

[miTutorials · Accepted solution]

The below tutorial should help you achieve what you are looking for.

Get another column value based on the Max Date or Max Value in PowerBI