Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Rolling Interval Calculation

Hi,   My dataset is as follows   Year     Month      Day_of_Month     Values    .           .                        .                     .   2017     12                     31                ...
Need Help
LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Hi Anonymous,

 

the correct way to handle this is through the creation of a Date dimension table but it does not look like it is the case for you?

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I don't have a date dimension , but a date column in  my Table

 

Power BI User

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Liviolanzo,

       

      I have created date dimension.

      Now what do i need to do to calculate rolling interval.

       

      Power BI User

      • LivioLanzo's avatar
        LivioLanzo
        Solution Sage
        7 years ago

        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)