predict future data

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

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.

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