Forum Discussion

Arendp's avatar
Arendp
Helper III
5 years ago
Solved

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_Refaei's avatar
    Mohammad_Refaei
    Solution Specialist

    Try to add ALLSELECTED ('Calendar'[Date])  to your DateRangeMin and DateRangeMin measures.

  • Thanks for your reply!

    I managed to solve it otherwise. The datediff was achieved also by a countrows on my second datetable.