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.
Select a end date from a filter and use it to calculate last 90 days and last 120 days. The Custom End date should not apply to any visual on the report. it should only be used for calculation (last 90 and 120 days)
I am currently doing this
Solved! Go to Solution.
Thanks a lot for your responses! I used a disconnected date table to get the end date now this code works perfectly!
Thanks a lot for your responses! I used a disconnected date table to get the end date now this code works perfectly!
Hi,
This pattern should work. I have assumed that you have already written a measure named MaxDate.
VAR OneYearAgo = CALCULATE(COUNTROWS('DateTable'),DATESBETWEEN(Calendar[date],[MaxDate]-90,[MaxDate]))
Is that 'DateTable' disconnected from your data model?
No the datetable is connected
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 |
---|---|
106 | |
102 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |