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.
I have some data that I am trying to run some forecasting with. My boss would like to extend until 2025, which would be 76 data points from today with my monthly data. I have 104 datapoints of months dating back to July of 2010. I currently have 308. When I project out 36 months it takes me up to 347 as you will see below. When I project out 76 months, I get 305, which is a regressiong which is not what I am going for. I will likely tell my boss that we should go with the 36 month forecast, but I'd like to have an explanation as to why PBI decided that in 36 months I'll have a growth of 13% as oppose to a minor loss for 76 months?
Solved! Go to Solution.
I don't believe the actual models are public but read up here:
https://community.powerbi.com/t5/Desktop/Forecast-Functionality-in-PowerBI/m-p/125337#M53062
https://community.powerbi.com/t5/Desktop/Forecasting-in-Power-BI-The-Theory/m-p/366740#M165962
https://www.mssqltips.com/sqlservertip/5085/data-forecasting-and-analytics-with-power-bi-desktop/
Also, you could just do it yourself. https://community.powerbi.com/t5/Quick-Measures-Gallery/De-Seasonalized-Correlation-Coefficient/m-p/...
I don't believe the actual models are public but read up here:
https://community.powerbi.com/t5/Desktop/Forecast-Functionality-in-PowerBI/m-p/125337#M53062
https://community.powerbi.com/t5/Desktop/Forecasting-in-Power-BI-The-Theory/m-p/366740#M165962
https://www.mssqltips.com/sqlservertip/5085/data-forecasting-and-analytics-with-power-bi-desktop/
Also, you could just do it yourself. https://community.powerbi.com/t5/Quick-Measures-Gallery/De-Seasonalized-Correlation-Coefficient/m-p/...
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |