Accumulated Rolling 12 Months

[Anonymous]

Hello,

I am trying to create a bar chart as shown in below picture which has Month-Year on x-axis and no of tickets on Y-axis. It has to show rolling 12 months until previous month i.e., In Dec-2020, the chart should show Dec-2019 to Nov-2020, this was achievable. The challenge is - how do i get the accumulation of values over months as in below image?

i.e., 2019-Dec = SUM(Dec-19)

      2020-Jan = SUM(Dec-19 + Jan-20)

      2020-Feb = SUM(Dec-19 + Jan-20 + Feb-20)

      .

      .

      .

      2020-Nov = SUM(Dec-19+Jan-20+Feb-20+....+Nov-20)

Thank you.

[Ashish_Mathur]

Hi,

Assuming you have a Calendar table and that you have dragged Year and Month from the Calendar table to your visual, try these measures

Total = sum(data[value])

Running 12 months total = calculate([total],datesbetween(calendar[date],edate(min(calendar[date]),-11),max(calendar[date])))

Hope this helps.

[v-yuaj-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, you can create a calculated column as follows.

calculated_value = SUMX(FILTER('Table5',[date]<=EARLIER(Table5[date])),[value])

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[littlemojopuppy]

Rolling 12 Months Average in DAX - SQLBI