From the course: Power BI: Integrating AI

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Using the LINEST DAX function

Using the LINEST DAX function - Power BI Tutorial

From the course: Power BI: Integrating AI

Start my 1-month free trial Buy for my team

Using the LINEST DAX function

“

- [Instructor] We can more efficiently calculate linear regression model coefficients and statistics with the help of DAX functions, like LINEST and LINEST X. We can also use these functions to calculate multiple regression with more than one independent variable in addition to linear regression with a single independent variable. The LINEST function as two required input parameters with the dependent variable going to the expression first, followed by the independent variables. We can run multiple regression models by adding additional independent variables into the expression after that. Let's first create a new calculated table that we'll call Linear Regression, where we'll set it equal to the LINEST function. We'll then input the High Temperature field as our first function parameter representing the dependent variable, and we'll use the field for low temperatures as our independent variable input, and notice we're referencing columns here. If we navigate to the data view, we can…

Contents