To get Latest Sales Date for each client using DAX

[Anonymous]

Hi,

I have a requirement to see the Latest Sales date for each client as shown in the screenshot.
I am using this DAX Measure:

Latest Sales Date = CALCULATE( MAX('Transaction'[Transaction Date Key]),ALLEXCEPT(Client,Client[Instance Name]))

Here is how my data model is:

So basically I am trying to look for the latest date on which the Sales were made by each client.
Can someone pls help me with this. Thanks in advance.

I can also provide more information if required.

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

=CALCULATE( MAX('Transaction'[Transaction Date Key]),ALL('Transaction Date','Transaction Date'[Month Year]))

If it does not, then share the link from where i can download the PBI file. 

[Anonymous]

Hi @Ashish_Mathur ,
Yes this logic works

Latest Sales Date = CALCULATE( MAX('Transaction'[Transaction Date Key]),ALL('Transaction Date'))
Thanks👍

[Ashish_Mathur]

You are welcome.