Forum Discussion

raylenes12's avatar
raylenes12
Frequent Visitor
8 years ago
Solved

Average by Year

I haven't been able to find a way to calculate the average of '12 Qtr Moving Average' by year. I've searched other topics on this question but the formulas haven't worked yet. I'm not sure what I nee...
Need Help
  • raylenes12's avatar
    raylenes12
    8 years ago

    I was able to find the formula using Quick Measures. Here it is in case anyone else comes across this question.

     

    12 Qtr Moving Average =
    AVERAGEX(
    KEEPFILTERS(VALUES('DateDimension'[QuarterAndYearNumber])),
    CALCULATE('MainData'[12 Qtr Moving Average2])
    )

raylenes12's avatar
raylenes12
Frequent Visitor
8 years ago

I was able to find the formula using Quick Measures. Here it is in case anyone else comes across this question.

 

12 Qtr Moving Average =
AVERAGEX(
KEEPFILTERS(VALUES('DateDimension'[QuarterAndYearNumber])),
CALCULATE('MainData'[12 Qtr Moving Average2])
)