cancel
Showing results for
Did you mean:
Helper IV

## Calculate sums of 12 months rolling year

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

Thanks

Super User

@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

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors