Simple Linear Regression
This measure allows you to predict dependent values Y from independent values X.
NAME:
Simple linear regression
DESCRIPTION:
Estimate Y values based on X values.
PARAMETERS:
N...
Thanks for the measure Daniil, it is extremely helpful.
I am attempting to apply it to a forecasting problem that is relatively simple in excel, but is causing some trouble for me with Dax/PowerBI. I have 19 different categories that I need to run the regression on, and then I need to sum those categories for use on further regressions. Could your measure be modified to accomplish this or do I need to create 19 different measures?
Thanks for any help you could provide.
I reckon DAX might be cumbersome for this. You can consider installing python in Power BI to generate a linear model for your analysis. jwjwjwjwjw