Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
Solved! Go to 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.
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.
Hi @Ashish_Mathur ,
Yes this logic works
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |