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
cferv_77Helper I
Helper IHello amitchandak ,
I am having trouble with the DAX formula when I change the year to 2021. It works fine when I put it in a table, but when I use it in a bar visual keeps giving me the total number for that year instead of for that month.
Any suggestions to fix this?