Calculate sums of 12 months rolling year

[Medmbchr]

Hi

I would like to calculate the sum of consumptions over a 12 month rolling period, but for each month.

Exemple:

We are in December 2022, hence I would like the following:

- Sum of consumption in October 22

- Sum of consumption in September 22

- ....

- Sum of consumption in December 21

I tried to use DATESINPERIOD but doesn't seem to work out

Any leads?

Thanks

[amitchandak]

@Medmbchr , with help from date table

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

Rolling 12 till last 2= CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],eomonth(MAX('Date'[Date])-2) ,-12,MONTH))

Rolling 12 till last 1= CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],eomonth(MAX('Date'[Date])-1) ,-12,MONTH))

You can use -11 or -10 as per need

Rolling Months Formula: https://youtu.be/GS5O4G81fww