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

[Anonymous]

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

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

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):

You could also download the pbix file to have a view.

Regards,

Daniel He

[Ashish_Mathur]

Hi,

There is no file.

[Anonymous]

Hi Mattheu,

See this image and tell us if works for you.