Linear Regression

[Torbenan]

Hi

I've got a table like this

year    Sales

2012  10

2013  12

2014  13

2015  13

2016  16

2017  15

2018  17

In can put this in to a Line Chart Visual and a Trend Line. This will show me the Sales Trend. I want to find the slop of the trend line by using a linear regression in DAX. How do I do that?
It's very simple in Excel

[jdbuchanan71]

Hello @Torbenan 

Take a look at this excellent post by Daniil Maslyuk. https://xxlbi.com/blog/simple-linear-regression-in-dax/

[Torbenan]

Thank - that seems to be the way to go. Just wonder, why this i so simple in Excel (=LINREGR(B3:B9;A3:A9)) and so complicated in Power Bi

[jdbuchanan71]

Because Excel is 25 years older than DAX.   They add new features every month so you may see something like LINREGX(table,expression) in the future.