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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.