Linear regression calculation

[Anonymous]

Hello,

Is there a way to calculate with DAX the linear regression of this:

Sites	Entity code	Result Moisture	Result aw
RCR	5369	8,2	0,56
RGU	5285	7,4	0,51
RGU	5071	7,8	0,48
RFT	5459	6,5	0,5
RCR	5369	8	0,54
RGU	5071	7,6	0,46
RGU	5285	7,9	0,55
RCR	5369	7,7	0,53

x = Moisture results

y = aw results

And for each site/formula, I will use the linear regression calculation to estimate my aw result when moisture = 9,5 % or 10,5 %.

Thanks for your help,

Hervé

[vanessafvg · Accepted solution]

does this help at all?

https://www.bluegranite.com/blog/simple-linear-regression-in-power-bi