Find Latest Transaction Date for Each Customer

I have successfully used LASTDATE.

Customer Last Transaction = LASTDATE('Sales'[OrderDate])

Then I populate the rows with the customer ID. My sales table is matched to my customer table using the ID.

heathernicole I have not read the whole post but give this a try...

Last Transaction =
CALCULATE (
    LASTDATE ( 'Sales Details'[SalesTxnTimeModified] ),
    ALLEXCEPT ( 'Customer', 'Customer'[Customer Name] )
)

Hello heathernicole! I don't know what to tell you???

I use this exact Measure to calculate Last Payment by Purchaser - and there are MANY MANY duplicate dates!

I just tried it and it works as a Calculated Column as well.

You know the May Update was released today - have you updated? (Even though this should not be the issue!)

https://powerbi.microsoft.com/en-us/blog/

heathernicole Try this...

Go to Modeling Tab => Click New Table button => type this...

Summary Table =
SUMMARIZE (
    'Sales Details',
    'Sales Details'[Customer ID],
    "Last Transaction", MAX ( 'Sales Details'[SalesTxnTimeModified] )
)