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
