Cumulative/Rolling Sum for 3 months

[Rojali]

Hi,

I have tried to calculate Rolling Sum for 3 months (in reverse order),

"Rolling 3 months sum = CALCULATE([Sales %],DATESINPERIOD('Datetable'[Date],MAX('Table'[Date]),-3,MONTH))"

But DAX returns some weird values. I have created separate Datetable/Calender table even, but still the DAX is not working. 

Thanks.

[amitchandak]

@Rojali , try like

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

[Rojali]

@amitchandak : That's not working too...