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

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors