Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm having trouble returning the 2nd to last MAX invoice date inside DAX when I am filtering in Matrix by Client with drilldown to JobID. (Just for reverence, it is 1 Table - Invoices. All Invoices have a Client allocated to it and a JobID. So a Client can have many JobIDs)
The Last Date is no issue
Solved! Go to Solution.
Went a SQL path to solve this.
It seems that you may change "<>" to "<".
This doesn't seem to work. In August context, looking at 1 particular JobID, it returns 30/08/2019
It should be returning 31/07/2019, as this was the last invoice raised for this Job. 30/08/2019 makes no sense, as no invoice was raised on this date for this job.
DAX
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |