Running Total issue

[Priya2007]

Hi All,

I am trying to get 36 months running total .

My Measure :

Unnassisted Pole Failures (3 Yrs) =

Var Result =

CALCULATE(

[Monthly Pole Failures],

FILTER(

CALCULATETABLE(

SUMMARIZE('Incidents', 'Incidents'[Start_Of_Month], 'Incidents'[Month]),

ALLSELECTED('Incidents')

),

ISONORAFTER(

'Incidents'[Start_Of_Month],max(Incidents[Start_Of_Month]), DESC )&& 'Incidents'[Start_Of_Month]<= max(Incidents[Start_Of_Month]))

)

return result

This measure is giving running total for all years but I am looking for every 36  months.

[lbendlin]

yes, somewhere in your measure you need to specify the 36 month range filter. Please provide sample data in usable format (not as a picture) and show the expected outcome.