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.
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.
Solved! Go to Solution.
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
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-TIT...
Still do not know what you want. Sample data, expected output from sample data and an explanation to get from A to B. Really helps.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |