Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 clearly show the Forecast and Actual Sale Difference. The Forecast must change dynamically with Filter Selection.
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
Appreciate any answer and guidance.
Thanks in advance,
Amz
Solved! Go to Solution.
Hi @Amz_123 ,
I found a same thread. And the engineer @Icey posted an answer. Please check if it is what you want.
library(gridExtra)
library(quantmod)
library(forecast)
library(tseries)
ARIMA_Sales<-ts(dataset$Sales,start=c(1))
Sales_Forecast<-auto.arima(ARIMA_Sales,seasonal=TRUE)
Predicted_Sales<- forecast(Sales_Forecast, h=10)
Predicted_Sales<-data.frame(coredata(Predicted_Sales))
grid.table(Predicted_Sales)
https://community.powerbi.com/t5/Desktop/Power-BI-Forecast/m-p/887659#M425483
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.
Hi @Amz_123 ,
I found a same thread. And the engineer @Icey posted an answer. Please check if it is what you want.
library(gridExtra)
library(quantmod)
library(forecast)
library(tseries)
ARIMA_Sales<-ts(dataset$Sales,start=c(1))
Sales_Forecast<-auto.arima(ARIMA_Sales,seasonal=TRUE)
Predicted_Sales<- forecast(Sales_Forecast, h=10)
Predicted_Sales<-data.frame(coredata(Predicted_Sales))
grid.table(Predicted_Sales)
https://community.powerbi.com/t5/Desktop/Power-BI-Forecast/m-p/887659#M425483
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.
Hi @Amz_123 ,
I'm not good at R. If you have to implement it with R, maybe @TomMartens can help you. He's a very professional engineer.
The following links are the videos and blog about forecasting with DAX. Hope they can help you a little bit.
https://www.youtube.com/watch?v=U7sl7guoxMI
https://www.youtube.com/watch?v=R_hB2hJv04I
https://www.youtube.com/watch?v=njjEkkoyxl0
https://www.sqlbi.com/articles/showing-actuals-and-forecasts-in-the-same-chart-with-power-bi/
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |