Forum Discussion

Priya2007's avatar
Priya2007
Frequent Visitor
5 years ago

Running Total issue

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.
 
 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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.