Home » Science & Technology » The New LINEST() DAX Function in Power BI - Regression Analysis Made Easy #regressionanalysis

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

Written By Data Analytics Central on Saturday, Feb 18, 2023 | 04:02 PM

 
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/1VLkYGLA_J16Qtze5S6ThEUdffX1f7qmJ/view?usp=share_link The dataset used in this tutorial is called Salary_Data from Kaggle.com #dax #powerbi #linest #dataanalysis #businessintelligence #linearregression #regressionanalysis

Disclaimer:
All images, musics and videos copyright are belong to their respective owners. We just put embed contents from Youtube.com and do not host any content in our server. These content(s) may be protected by copyright law or other laws regarding intellectual property of the United States or other countries. Downloading file(s) on this site is just for review purpose. If you love the song, please support the artists by buying the original CD/Cassette or buying the song from iTunes.