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 t...
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.
