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

Simple linear regression.pbix66 KB

Mathematical

jwjwjwjwjw

Advocate II

8 years ago

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.

mski_dev

New Member

7 years ago

Daniil, (or anyone else knowledgeable)

Many thanks for this but I am struggling a little with adapting it to my needs, as I am still quite new to DAX.

I am trying to create a sales prediction model and want to use the linear trend from just the last 12 months, I believe your current code will give me the linear regression from all of the data.

How do a go about just using the last 12 months of data to feed the regression.

Many thanks for anyone that might be able to help,

Mark.