Forum Discussion
Dax Calandar weeks like Relative date filter
I'm wanting to make a Dax statement that is like the relative date filter. I have other measures that would be impacted if I use the filter.
hi Anonymous
Try to create a measure as below:
CALCULATE ( [Expression], FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) && YEAR ( 'Date'[Date] ) = YEAR ( MAX ( 'Date'[Date] ) ) && WEEKNUM ( 'Date'[Date] ) = WEEKNUM ( MAX ( 'Date'[Date] ) ) ) )If not your case, please share the sample pbix file and your expected output.
Regards,
Lin
4 Replies
hi Anonymous
Try to create a measure as below:
CALCULATE ( [Expression], FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) && YEAR ( 'Date'[Date] ) = YEAR ( MAX ( 'Date'[Date] ) ) && WEEKNUM ( 'Date'[Date] ) = WEEKNUM ( MAX ( 'Date'[Date] ) ) ) )If not your case, please share the sample pbix file and your expected output.
Regards,
Lin
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Particularly, what is the output you are expecting?
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008Still do not know what you want. Sample data, expected output from sample data and an explanation to get from A to B. Really helps.
