Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |