The New LINEST() DAX Function in Power BI - Regression Analysis Made Easy

The new DAX function LINEST() is a new powerful tool in your Data Analysis skillset.

It is the easiest way to do Regression Analysis. And Regression Analysis is a fundamental concept in Data Science.

LINEST() function uses the Least Squares method to calculate a straight line that best fits the given data, then returns a table describing the line.

The equation for the line is of the form: y = Slope1*x1 + Slope2*x2 + ... + Intercept.

While we had this function in Excel for many years, only with this month update we have it in Power BI.

====CHAPTERS====
01:23 LINEST() documentation
02:40 LINEST table creation
03:20 Equation for linear regression
04:30 Parameters table (years)
07:07 Measure for selected years
08:13 2nd Equation for prediction

Here is the link to the pbix file:

https://drive.google.com/file/d/1VLkY...

The dataset used in this tutorial is called Salary_Data from Kaggle.com

#dax #powerbi #linest #dataanalysis #businessintelligence #linearregression #regressionanalysis