DAX measures to find financial amount of the latest transaction per contact/customer

[jonclay]

Hi all
I've created a DAX Measure as follows to SUM together the total of 3 fields:

Nett = SUM(transaction[dc1amount]) + SUM(transaction[dc2amount]) + SUM(transaction[dc3amount])

I've then create another DAX Measure to find the latest date of my Transactions. This has then been put into a table against various contacts so that it effectively finds the date of the latest Transaction per contact/customer:

Latest_Gift_Date =

MAXX (

    FILTER (

        transaction,

        transaction[status] = "Paid"

    ),

    transaction[dateofpayment]

)

What I'm trying to do next (and failing!) is to find the amount of the latest Transaction per contact/customer. Could anyone please supply me with the correct DAX for this based on the two measures shown above?

Many thanks
Jon 

[jonclay]

Hi @HoangHugo 

Thank you so much, that works fine!

Best wishes
Jon

[HoangHugo · Accepted solution]

Hi, try this

measure

Latest_transaction = CALCULATE([Nett measure],transaction[dateofpayment]=[Latest_Gift_Date])