Replicate Line Chart Forecast Feature to DAX?

[Anonymous]

Hi everyone,

wondering if anyone knows how to replicate the line chart forecast feature into the DAX measure?

[TomMartens]

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

[Anonymous]

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).

[Anonymous · Accepted solution]

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.