moving average calculation
1 Topic
Moving Average Calculation for Forecasting
Dear all, I would like to use Moving Average of actuals in the same period last year to predict my actuals in the rest of the year. I use line and stacked column chart to show the values. X-axis: Month Nr of year 2024 (only 2024 is selected) Y-axis: 1) Actual costs from month 1-6 (column), 2) Forecast costs from 7-12 (line) The Dax function I use for moving average calculation: Actuals MA = AVERAGEX(DATESINPERIOD(Dates[Date],LASTDATE(Dates[Date]),-30,DAY],[ActualCosts]) Actuals Forecast = IF(ISBLANK([ActualCosts], CALCULATE([Actuals MA], SAMEPERIODLASTYEAR(Dates[Date]))) If I use Dates[Date] as X-axis, everything will work, however, the Actuals Forecast does not sum up on month level. How can I adjust my dax functions? (MovingAverage Dax Function is not availble in my PBI version) Thanks in advance!Solved1.3KViews0likes1Comment