The New LINESTX() DAX Function in Power BI - Clearly Explained
HTML-код
- Опубликовано: 8 сен 2024
- 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
hi thanks for this, can you please upload a video that calculates p value for hypothesis please.
Hi Nisha, thanks for the feedback. I will put your suggestion in the list of future videos!
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.
Thanks for the feedback! 🙏