Forum Discussion
Advanced Date Filtering using DAX
Good day, I have data quesry consists of number of Execel files. Query has colunms "SHIP NAME" and "Date of Reports". Some of the "SHIP NAME" repeats various times with different "DATES". W...
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?
THnaks
Aleks
#help needed