cancel
Showing results for
Did you mean:
New Member

## Accumulated - doing accumulated 12 months for every month of the axis x

Guys, good morning.

I'm trying to create accumulated measure but I'm not getting it. Actually it's a different accumulation, since I want it to show me on the x axis the last 6 months and the value of each month is the accumulated 12 months back.

ex:

the X Axis contains 6 months (June / 18, July / 18, August / 18, September / 18, October / 18, November / 18). The value that will show in June / 18 is the sum of July / 17 until June / 18 (last 12 months), the amount that will show in July / 18 is the sum of August / 17 until July / 18 (last 12 months) and so on. That is, each month it makes the accumulated 12 months back. can you help me?

I have attached a file to make it base to make the formula. I put a page filter with a relative date of the last 6 months, but I can not do this accumulation.

Thank you,
Mattheu

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: Accumulated - doing accumulated 12 months for every month of the axis x

Based on my test, you could refer to below steps:

Sample data:

Create a new calender table:

`date = CALENDARAUTO()`

Create a measure:

`Measure = CALCULATE(SUM(Table1[Value]),DATESINPERIOD('date'[Date],MAX('date'[Date]),-12,MONTH))`

Result(I have set a visual slicer on it to show the last 6 month):

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Highlighted
Anonymous
Not applicable

## Re: Accumulated - doing accumulated 12 months for every month of the axis x

Hi Mattheu,

See this image and tell us if works for you.

Super User IV

## Re: Accumulated - doing accumulated 12 months for every month of the axis x

Hi,

There is no file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Microsoft

## Re: Accumulated - doing accumulated 12 months for every month of the axis x

Based on my test, you could refer to below steps:

Sample data:

Create a new calender table:

`date = CALENDARAUTO()`

Create a measure:

`Measure = CALCULATE(SUM(Table1[Value]),DATESINPERIOD('date'[Date],MAX('date'[Date]),-12,MONTH))`

Result(I have set a visual slicer on it to show the last 6 month):

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft

## Re: Accumulated - doing accumulated 12 months for every month of the axis x

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors