Polynomial Regression Trendline

[PBIUSER_01]

Hi all,

Is it possible to generate a polynomial regression trendline of degree two in Power BI similar to Excel using the LINEST function? I'm expecting two slope values and a coefficient as a result to calculate the trendline equation (y = slope1 * x^2 + slope2 * x + coefficient).

Thanks in Advance,

[Anonymous]

Hi @PBIUSER_01 

It seems that you have gotten a solution. Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards    

Zhengdong Xu

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

[tharunkumarRTK · Accepted solution]

@PBIUSER_01 

Power BI has introduced LINEST and LINESTX functions. I think you can use these functions to perform polynomial regression as well.

https://dax.guide/linest/

https://dax.guide/linestx/

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun