Forum Discussion
Linear Regression
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
3 Replies
Hello Torbenan
Take a look at this excellent post by Daniil Maslyuk. https://xxlbi.com/blog/simple-linear-regression-in-dax/
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
Because Excel is 25 years older than DAX. :smileyhappy: They add new features every month so you may see something like LINREGX(table,expression) in the future.
