Forecast Using AI/ML

[Anonymous]

Hi,

Can anyone help in how to do a Forecasting using AI/ML? I´ve data from customer complaints and I want to forecast the next month.

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

If you know the logic of forecasting, maybe you can use DAX, please refer this post.

If you don't konw the logic, mabybe you can achieve it in Analysis pane using a line chart. For example, when you want to show the next 3 months for forecast, you can set the Forecast Length as 3 months.

You can refer the following articles:

Predict your milestones with forecasting in Power BI Desktop

Forecast Seasonality

Best regards,

Community Support Team _ zhenbw

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

[amitchandak]

@Anonymous , There some forecasting in Power BI.  But you can integrate with R and python

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
https://en.blog.businessdecision.com/how-to-use-the-python-integrator-in-powerbi/
https://towardsdatascience.com/using-python-in-power-bi-ee95a6b71443
https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/

[Anonymous]

Thank you @amitchandak .

And what if I want to forecast without AI/ML? 

[amitchandak]

@Anonymous ,

see if this can help

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

[nvprasad]

Hi,

To create any model using R or Python, first, we need to install in machine. then you can find Arima model code in net and you can use to create the forecast.

Note: PowerBI supports up to 150000 rows only. If data exceeds to this, by default powerbi ignores and results shown based on the first 150000 rows only. If you have data more than 1.5 k then summarize and load data into the model.

Thank You,

Regards,

Venkata Nalla