Create a Linear Regression in Power Query

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.