Forum Discussion
Rolling Interval Calculation
Anonymous
you need to start by creating one: http://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Hi Liviolanzo,
I have created date dimension.
Now what do i need to do to calculate rolling interval.
Power BI User
Hi Anonymous
perfect! Now you can relate the Date dimension with the fact table if not already done. Afterwards you need to mark it as a Date table
Then you just need to change the filter within CALCULATE to point to the date dimension
DATESINPERIOD(DateTable[DATE],MAX(DateTable[DATE]),-60,DAY)
Hi LivioLanzo,
I tried doing this but it still gives me same result.
However while going through few test sets i realized this is not the problem.
Actually whenever i am using side filters (Year , Month , Day of Month) , the data set is filtered out hence it does not calculate rolling.
For example : if i select complete 2018 , then calculation is correct from 31 Jan 2018 onwards for Rolling Interval-1
If i select Feb-2018 only , data for Jan is filtered out , hence it gives sum of only february which is not the required result.
How do i make the filters work with the calculation.
Power BI User
Can you show a screen shot or share your file? You may need to created a disconnected table