Implementing linear regression in Power BI

preview_player
Показать описание
How to manage the LINESTX function results in DAX to compute linear regression.

  1. SQLBI
Рекомендации по теме
Implementing linear regression 0:13:52

Implementing linear regression in Power BI

PREDICT THE FUTURE 0:10:31

PREDICT THE FUTURE with LINEAR REGRESSION / How to use LINEST function / Beginners Guide to Power BI

How to do 0:09:10

How to do Simple Linear Regression in Power BI | Diana Arciniega

Linear Regression in 0:02:34

Linear Regression in 2 minutes

Stichprobengröße bei der 0:05:21

Stichprobengröße bei der multiplen linearen Regression mit G*Power

The New LINESTX() 0:08:20

The New LINESTX() DAX Function in Power BI - Clearly Explained #linearregression

The New LINEST() 0:10:28

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

Power Bi : 0:03:40

Power Bi : Evaluating my linear regression model

MLT | Quiz 0:51:47

MLT | Quiz 2 | PYQ | T1(2024) | Detailed solution | IITM BS | Data Science | Machine learning

Transforming nonlinear data 0:02:55

Transforming nonlinear data | More on regression | AP Statistics | Khan Academy

DAX Fridays! #135: 0:12:16

DAX Fridays! #135: Linear Regression in Power BI

Creating a Sports 0:17:19

Creating a Sports Betting Model 101 - Intro to Linear Regression (The simplest model ever created!)

Multiple regression: how 0:10:46

Multiple regression: how to select variables for your model

Simple Linear Regression: 0:07:27

Simple Linear Regression: Transformations

DAX for Power 0:16:48

DAX for Power BI - Predicting Days Until a Goal (Linear Regression)

How to predict 0:04:48

How to predict values using linear regression in power bi | Power BI scenarios videos

Linear Regression with 0:01:00

Linear Regression with Python in 60 Seconds #shorts

G*Power Linear Regression 0:04:01

G*Power Linear Regression

How to do 0:05:18

How to do a linear regression on excel

Power Bi : 0:35:33

Power Bi : Build a simple Linear Regression Equation in DAX to Predict a Goal

Multiple Linear Regression 0:01:16

Multiple Linear Regression in Power BI

How To... Perform 0:10:55

How To... Perform Simple Linear Regression by Hand

G*Power: Calculating Sample 0:03:49

G*Power: Calculating Sample Size in Multiple Linear Regression

AI Visualization - 0:04:58

AI Visualization - REGRESSION ANALYSIS & SEGMENTATION using KEY INFLUENCER visual | Power BI

Комментарии
Автор

Great video, Marco! Thank you for sharing this insightful tutorial. Typically, I perform regression analysis in Python and get the coefficients and intercept into Power BI for predicting values. However, with the LINESTX function in Power BI, I can now conveniently run the regression directly within Power BI and obtain the linear equation. This approach is highly efficient, dynamic and saves me time. Thanks again for introducing this helpful technique!

Nazeerul_Hazard
Автор

I assumed linest stood for linear estimator- hence the function would be pronounced lin-est. Not a problem though!
Thanks for all the great content. You guys are life savers

piaveipvsenlawp
Автор

Thank you for the video, Marco! It works! The question is - how to look for a linear regression for the future months where we still have no sales?

ekaterinap.
Автор

Hi,
So, for single row table the SELECTCOLUMNS() returns a scalar value, similar to VALUES().. Thank you!

Bharath_PBI
Автор

Thank you for this useful tutorial. Quick question: what would be the syntax for LINESTX if I want to filter the initial table? For example, in my table I have multiple product categories and I want calculate only for one of them. Would the formula become as below (assuming I am interested in Bikes)?
Table 3 = LINESTX
(FILTER('Table', 'Table'[Category]="Bikes"), 'Table'[Revenue], 'Table'[Sold date], TRUE)

mnedix
Автор

How about if I want to calculate for multiple products on the same plots?

gracechik
Автор

Hi! How many times are we calculating the linear regression? Seems to be expensive. Thanks for this video!

johansantacruz
Автор

Like, regards, from Cali Colombia. I suggest you use Excel's linear forecast function to explain this topic.

alvarorodriguezlasso
Автор

Great explanation. My brain is back to statistics

Wzxxx
Автор

Quick question, changing subject...any new about the issue in Bravo not running after PBI May update? Thanks.

elrevesyelderecho
Автор

Once you have created the linear regression measure, how do you actually add the line to your chart?

brynhumberstone
Автор

What about polynomial regression ? Is it possible?

lionels
Автор

Let's say I have a table with 100 products with all the Prices and Quantities. I'd like to do linear regression with many different products.
How do I use LINESTX in a smart way, avoiding to write 100 DAX queries?
How can I link a dropdown list of the products, located in one tab of our dashboard, to LINESTX function? Is that possible?

lorenzocassina
Автор

Yes I'm facing the same bug issue. How to solve this

aravindbabu
Автор

Does LINESTX still not work for polynomial regression?

kopite
Автор

Quite complicated, it is much easier to take the data back to excel or python and make the regression line

anindadatta