Rolling 3 month calculation

[mmills2018]

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

[amitchandak]

@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))