Рет қаралды 4,673
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/1oUxc...
#linearregression #regressionanalysis #powerbi #dataanalysis #businessintelligence #dax #predictiveanalytics