Forum Discussion

mmills2018's avatar
mmills2018
Helper IV
4 years ago

Rolling 3 month calculation

Hello,

 

I have been using the below calculation for all of 2021.  I recentely refreshed my workbook with 2022 data.  The below calculation is no longer working and i am at a loss. All my data fields are the same and my date table does include January 2022 data and prior years/months of data.  It actually returns a result but only $ (due to calc annualizing by 4).

 

DATESINPERIOD('Date Table'[Date],LASTDATE(Snapshots[Data as of]),-3,MONTH))*4
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    mmills2018 , Try to use a date table and try

     

    example

     

    Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))