Forum Discussion
Forecast Monthly Data
Hi Community,
Please guide me to forecast monthly Sales(Not as each day, it is as month) for next three months keeping the previous previous four years monthly Sales History. I want the forecast to be displayed in Table visual and find the difference between actual sales and forecast Sales, its accuracy.
I tried Forecasting using Linear Regression in DAX. Dax Forecasted value was same as in Excel Prediction function. Also, tried prediction using custom visual "Forecasting with ARIMA". The level of accuracy varied at a greater level between Custom Visual and Linear Regression prediction. I found "Forecasting with ARIMA" is great at prediction and closely match the actual sales.
But my problem here is, i am not able to display it in table visual. I want the algorithm used in "Forecasting with ARIMA" Custom Visual to be displayed in Table Visual. Only on showing in Table visual, it is able to easily and clearily show the Forecast and Actual Sale Difference. The Forecast should change dynamically based on Category selection in Filter.
For reference, i am attaching you the pbix. In this i have tried using Line Chart, Forecast using ARIMA and R-Script.
https://drive.google.com/file/d/1K5cHVSXGQDsFhl7F9GPEcDWZorUJQ2Wd/view?usp=sharing
Please provide any solution. Appreciate any answer and guidance.
Thanks in advance,
Sowmiya.
1 Reply
- v-eachen-msftCommunity Support
Hi Sowmiya ,
Here is a similar case for your reference:
https://community.powerbi.com/t5/Desktop/Finance-Forecast-using-DAX/m-p/318862
You could change it to month.