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 need to add to my model to make it work. I have tried formulas where '12 Qtr Moving Average' was a measure and a column.  Appreciate any help!

 

The Excel data table is set up as follows:

 

This is the end result I'm trying to accomplish. 

 

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])
    )

1 Reply

  • 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])
    )