Forecasting - how to add linear, exponential, and moving average to matrix

[Anonymous]

Hi,

I have a matrix in Power BI with Years in the columns, Months in the rows, and the monthly uits sold as the values. I would like to forecast this data based on the months to take into account the seasonality as well as 3 different methods to determine the most realistic forecast. I would like to have a column for linear forecasting, exponential triple smoothing, and moving weight average.

My Power BI file is here and I have included a pic of the Excel file showing the additional three columns that I would like to calculate using Power BI.

Thanks a lot!

Jeremy

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

The links may help you.

https://www.sqlbi.com/articles/showing-actuals-and-forecasts-in-the-same-chart-with-power-bi/ 

https://community.powerbi.com/t5/Desktop/Finance-Forecast-using-DAX/td-p/318862 

https://www.youtube.com/watch?v=vq3VOERJw7s 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the suggestions. I'm not sure this completely solves the problem but it gives me a good reference point to work with. Thanks, again for your help!