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

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.c...
#linearregression #regressionanalysis #powerbi #dataanalysis #businessintelligence #dax #predictiveanalytics

[@nishabhatt5268]

hi thanks for this, can you please upload a video that calculates p value for hypothesis please.

[@Data.Analytics.Central]

Hi Nisha, thanks for the feedback. I will put your suggestion in the list of future videos!

[@jignashasoni2129]

bro: I tried to hold myself from commenting because I don't like to, but you have got to be able to explain things properly. you seem utterly confusing.

[@Data.Analytics.Central]

Thanks for the feedback! 🙏