Forum Discussion
Replicate Line Chart Forecast Feature to DAX?
Hi everyone,
wondering if anyone knows how to replicate the line chart forecast feature into the DAX measure?
Hi Anonymous ,
It's possible. This blog shows how to create forward forecasts in Power BI using DAX.
In the blog, it is mentioned that you need to add a growth rate to the measure to calculate.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hey Anonymous ,
this article explains how you can implement linear regression using DAX: Simple linear regression in DAX – XXL BI
The article also contains links to other approaches.
This Microsoft article https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane?WT.mc_id=DP-MVP-5003068 is referencing an article that describes the concepts used for forecasting in combination Power BI: https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/#which?WT.mc_id=DP-MVP-5003068
Hopefully, this helps to tackle your challenge.
Regards,
Tom
Hi TomMartens,
thanks much for your reply!
The first links helps, but that translates the integrated trendline feature. I'd like to know if we can somehow calculate DAX (for table use eventually) for described in the 3rd link you posted (Forecast feature).
Hi Anonymous ,
It's possible. This blog shows how to create forward forecasts in Power BI using DAX.
In the blog, it is mentioned that you need to add a growth rate to the measure to calculate.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
