Forum Discussion
cferv_77
Helper I
Helper ICalculating Running Average of a Measure
I am trying to calculate a running average of a measure based on a year as its starting point. The company wants to use this formula to calculate “delivery rate”. (Annual) Delivery rate = [Runnin...
cferv_77 , Try like
calculate(AVERAGEX(values('Date'[Month Year]), [Open case]),FILTER(ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date]) && YEAR([Date]) = 2022))
refer if needed
amitchandak
Super User
Super Usercferv_77 , Try like
calculate(AVERAGEX(values('Date'[Month Year]), [Open case]),FILTER(ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date]) && YEAR([Date]) = 2022))
refer if needed
cferv_77Thank you that worked. Much appreciated.