predict future data

[powerbiexpert22]

what are the capabilities available in power bi which can predict future trends based on historical data.?

[Anonymous]

Hi @powerbiexpert22,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[anmolmalviya05]

Hi @powerbiexpert22, yes it is possible.

Please refer below table:

Capability	Use Case	Skill Required
Line Chart Forecasting	Quick trend prediction	Beginner
AutoML in Dataflows	Predictive ML without coding	Intermediate
Azure ML	Enterprise ML scoring	Advanced
Python/R Scripts	Custom forecasts	Advanced
DAX Trends	Trend analysis	Intermediate
Fabric Notebooks	Full ML pipeline	Advanced

If this post helps to answer your question, please consider accepting it as a solution so others can find it more quickly when they face a similar challenge.

Proud to be a Microsoft Fabric community super user

Let's Connect on LinkedIn

Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.

[TomMartens]

Hey @powerbiexpert22 ,

using DAX to calculate future values is possible, but not that simple. You can this post as a start: https://www.minceddata.info/2021/01/17/events-and-projections/

Of course, there are many articles describing the forcasting of future values, just search for "DAX forecast future value".

If you are using Fabric you can also leverage sempy to create forecast values, but this then is batch orientated: https://learn.microsoft.com/en-us/fabric/data-science/read-write-power-bi-python

However, calculating future values is not that simple 😉

Regards,
Tom

[pankajnamekar25 · Accepted solution]

Hello @powerbiexpert22 

yes you can do that forecasting etc stuff in Power BI using forecasting line option 

also you can use Azure Machine Learning Integration to work of AL/ML

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.