With simple linear regression, you can calculate them yourself, as long as you have sequential numeric values to use as known X values As soon as you use strings (month names, for instance), you lose the ability to add trend lines.
Linear regression has been done in DAX before (by Rob Collie and Greg Deckler, for instance), but my approach uses the new DAX syntax, which makes the calculations very easy.
Note how Dumbledore’s weight is unknown - we are going to predict it with simple linear regression. Let’s say you have the following data model: Name With simple linear regression, you can estimate the quantitative relationship between any two variables.
#Excel linear regression slope update
Update 2 December 2017: the sales example was updated to display the correct Estimated Sales figure at the grand total level. But first, why would you want to do such analysis? The two functions can be used for a simple linear regression analysis, and in this article I am sharing patterns to easily replicate them in DAX. As of 2017, some of the functions, such as SLOPE and INTERCEPT, exist in the latter but not in the former. DAX, originating in Power Pivot, shares many functions with Excel.