Create a Linear Regression in Power Query

[SteveIOW]

Hello All,

I am trying to create a Linear Regression such that I cna predict how long certain metrics will take to reach target, or how much activity is required to hit target by a certain date.

I have created the measures I need in Dax and it works fine. BUT the queries take so long to load I am concerned about memory and performance issues and am convinced there must be a better way.

My thought was to try it in Power Query during the Data load. The table looks as below. Can anyone suggest any blogs etc that I might use to help me do this please?

Kind regards

Steve

I need the regression to apply to TotalWL against each organisation and test type.

[amitchandak]

@SteveIOW , refer this blog - https://stephenroughley.com/2022/02/28/simple-linear-regression-in-power-query/