Dec 03 2022 04:37 AM
I am trying to calculate the following averages in an excel pivot table based on grouped fields using the
Dec 03 2022 12:33 PM
Afraid that's only with PivotTable based on data model using proper DAX measures.
Dec 04 2022 02:10 AM
Dec 04 2022 07:37 AM
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.