Forum Discussion

hadjigodih's avatar
hadjigodih
Copper Contributor
Dec 03, 2022

4 week Moving Average Calculated Pivot Table Field

I am trying to calculate the following averages in an excel pivot table based on grouped fields using the 

  1. 4 week rolling average
  2. 13 week rolling average
  3. 52 week rolling average

 

 

excel
Formulas and Functions

3 Replies

    • hadjigodih's avatar
      hadjigodih
      Copper Contributor
      Dec 04, 2022
      Thank you. Would you happen to know how I calculate the measures to achieve the averages I am looking for?
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Dec 04, 2022

        hadjigodih 

        Similar discussion is here Help with moving average of a DAX measure - Microsoft Community Hub , you may google something like "DAX moving average". Lot of sample, mainly for Power BI but majority of them are applicable to Excel Power Pivot.

         

        However, if you never worked with data model that could be quite long learning path. Perhaps you may consider other options with formulae. All depends on source data and desired results.

Resources