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).

Watch it on my YouTube channel https://www.youtube.com/@Data.Analytics.Central