Forum Discussion
Advanced Date Filtering using DAX
Hi Anonymous
Can you add a sample of your data and result here?
For the Max Date measure, you can use LASTDATE ('RNA Date of Report'[Date of Report])
Max Date=LASTDATE ('RNA Date of Report'[Date of Report])
and then if you want to use that in the other measure, you can add a variable in your measure like this:
IsLatest =
VAR _MaxDate =
CALCULATE (
LASTDATE ( 'RNA Date of Report'[Date of Report] ),
ALLEXCEPT ( 'RNA Date of Report', 'RNA Date of Report'[Ships Name] )
)
RETURN
IF (
'RNA Date of Report'[Date of Report] = _MaxDate,
"Latest Audit",
"All Audits"
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Good day,
Thnaks for reply. What I'm looking for is the new measure which will filter out date previous to last. The above one is not helping me, or I;m doing something wrong.
Kidn Regards
Aleks
Raally looking for solution how to use DAX function to recognize LATEST, Previous Date for each line.
I use below functions to recognize latest, but cannot progress more ("all audit"s need to be broken down on more conditions)
1) Max Date = calculate(max('RNA Date of Report'[Date of Report].[Date]), filter('RNA Date of Report', 'RNA Date of Report'[Ships Name]=EARLIER('RNA Date of Report'[Ships Name])))2) IsLatest = If('RNA Date of Report'[Date of Report].[Date]='RNA Date of Report'[Max Date].[Date],"Latest Audit", "All Audits")Any more ideas?THnaksAleks#help needed