(Note: This article was first published on LinkedIn) This article mainly introduces how to use DAX to complete multiple linear regression in PowerBI for time series analysis. Next, I will introduce the idea of “ridge regression” and “Lasso regression” into the model optimization. The multiple linear regression formula is as follows: Image by Wikipedia DAX can not perform matrix operations, so the regression formula refers to Klim’s law.
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile