Time Series forecasting

[shivambhat]

    

 I am trying to create  time  series forecasting for future  years,but as  you cann see  that  I don't have   enough data, only for  2022.  I am totally new to concept of forecasting & tried  adding 6 months in foresting lengh which should give  me  trendline  for  6 months,but it doesn't show  me anything. Can someone please  guide me  on this  as  I am not really sure if I am doing the right thing ?

Any help would be much appereciated  🙂

[v-henryk-mstf]

Hi @shivambhat ,

According to your description, creating forecasts in Power BI is easy, but very limited. For example, it is not possible to extract forecasts for metric values or calculate columns, but it is possible to do so by using a temporal model in R or python.

Refer to the following steps:

• Initialize the Libraries
• Load the Dataset and Visualize it
• Resample the Data
• Predict the Demand Through Facebook Prophet Model
• Measuring Model’s Performance and further steps

Also, for more details you can read below blog:

Describing the forecasting models in Power View | Microsoft Power BI Blog | Microsoft Power BI

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@shivambhat , refer if these can help

https://www.youtube.com/watch?v=BSwECAgT-oY

https://community.powerbi.com/t5/Desktop/Forecast-Using-AI-ML/td-p/1184505

https://iterationinsights.com/article/r-and-python-in-power-bi/