Forum Discussion
Constant Average & Cumulative Average
I want to calculate a constant average for weeks from 29 to 41. Test Avg Measure Before Period = AVERAGEX(SUMMARIZE( FILTER( Date_Dim, Date_Dim[FISCAL...
My Sample Data:
| FiscalYearWeek | Test Avg Measure Before Period | Test Avg Measure After Period | Total Sales Group M Vs Group N Var |
| 2023- W29 | ($2,843) | ($2,843) | |
| 2023- W30 | ($3,804) | ($3,804) | |
| 2023- W31 | ($2,676) | ($2,676) | |
| 2023- W32 | ($1,881) | ($1,881) | |
| 2023- W33 | ($3,315) | ($3,315) | |
| 2023- W34 | ($5,482) | ($5,482) | |
| 2023- W36 | ($3,915) | ($3,915) | |
| 2023- W37 | ($3,675) | ($3,675) | |
| 2023- W38 | ($2,908) | ($2,908) | |
| 2023- W39 | ($2,842) | ($2,842) | |
| 2023- W40 | ($3,422) | ($3,422) | |
| 2023- W41 | ($2,630) | ($2,630) | |
| 2023- W42 | ($3,362) | ($3,362) | |
| 2023- W43 | ($1,455) | ($2,909) | |
| 2023- W44 | ($1,582) | ($4,746) | |
| 2023- W45 | ($1,070) | ($4,280) | |
| 2023- W46 | ($1,006) | ($5,028) |