LINESTX() is iterative, meaning that it evaluates each row in a table, giving you ultimate control on the data points used (while LINEST() works only with entire columns).
Also, unlike Linest, LinestX can take columns from different tables.
I present step-by-step a real world example where we aggregate the data in the Transactions table (the dependent variable) and use another column from the Calendar table (the independent variable).
====CHAPTERS====
01:13 The Data Model
03:05 LINESTX() explained
05:40 The Regression Equation
07:04 The Parameters table (Years)
The pbix file:
drive.google.com/file/d/1oUxchm7etojTV0_gNxjUH1A8r6vXSOMN/view?usp=share_link
#linearregression #regressionanalysis #powerbi #dataanalysis #businessintelligence #dax #predictiveanalytics
- The New LINESTX() DAX Function in Power BI - Clearly Explained #linearregression ( Download)
- The New LINEST() DAX Function in Power BI - Regression Analysis Made Easy #regressionanalysis ( Download)
- PREDICT THE FUTURE with LINEAR REGRESSION / How to use LINEST function / Beginners Guide to Power BI ( Download)
- Implementing linear regression in Power BI ( Download)
- How to do Simple Linear Regression in Power BI | Diana Arciniega ( Download)
- Tutorial: Power BI: February 2023 Update: Simple Linear Regression using LINEST() DAX Function ( Download)
- Power Bi : Evaluating my linear regression model ( Download)
- Power BI Tutorial – Linear Regression - Es ( Download)
- Trend line for parallel data series with LinestX and Measure Driven Data Labels ( Download)
- 3.3 .Introduction to DAX | Min & MinX | Power BI for Everyone ( Download)
- Power Bi : Build a simple Linear Regression Equation in DAX to Predict a Goal ( Download)
- NON LINEAR Regression with Power BI - Logarithmic Growth #nonlinear #regression ( Download)
- How to predict values using linear regression in power bi | Power BI scenarios videos ( Download)
- EXPON.DIST - DAX Guide ( Download)
- CONTEXT TRANSITION - the most difficult DAX concept clearly EXPLAINED ( Download)
