Forum Discussion
previous period calculation based on variable time range
hello, I am struggling with the following calculation.
I have date slicer, where a user can select a variable time period.
For example user selects 3.May.2021 till 5.May.2021.
I want to compare figures with the same amount of days before.
So previous period will be 30.April.2021 till 2.May.2021.
How to create the calcuation for the period before? I have a DateRangeMin vs Max, but it works on total level only, not when I want to calculate it for each date in the time frame.
Here it needs to be -3 for each line, so I can calculate back to each previous period line with the function dateadd(date,-3,day).
So right now 3.May looks at 2.May, 4.May looks at 3.May, while it should be: 3.May look at 30.Apr, and 4.May looks at 1.May.
Hopefully my question is clear and somebody can point me in the right direction.
Thanks for your reply!
I managed to solve it otherwise. The datediff was achieved also by a countrows on my second datetable.
2 Replies
- Mohammad_RefaeiSolution Specialist
Try to add ALLSELECTED ('Calendar'[Date]) to your DateRangeMin and DateRangeMin measures.
- ArendpHelper III
Thanks for your reply!
I managed to solve it otherwise. The datediff was achieved also by a countrows on my second datetable.