Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jonclay
Helper IV
Helper IV

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

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 



1 ACCEPTED SOLUTION
HoangHugo
Solution Specialist
Solution Specialist

Hi, try this

measure

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

View solution in original post

2 REPLIES 2
jonclay
Helper IV
Helper IV

Hi @HoangHugo 

Thank you so much, that works fine!

Best wishes
Jon

HoangHugo
Solution Specialist
Solution Specialist

Hi, try this

measure

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.