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

tonymaclaren

Helper I

8 years ago

Hi Daniil

Thanks again for all your help. I have attached the whole file because it might interest you anyway. I sholuld stress it is a work in progress and my first use of Power BI. Please keep it to yourself.

The page labeled Tony Data with the table in it shows the problem clearly--although it does not reproduce in the chart on that page. It is not really a problem, but it would be nice for us to understand the behaviour.Play around with the date slider and you will notice that if you set the start date to 1960 only you see -32.72 at the top and bottom of the [Estimated Tony Data] column. Other start dates do not exhibit this problem.

I will take a look at the blog.

Tony

Central England Temperature.pbix933 KB

leanh

Regular Visitor

8 years ago

Aye Tony, hope my suggestion could work for you with such problem:

You can try replacing this part:

RETURN
Intercept + Slope * SELECTEDVALUE ( 'Tony_data'[YEAR])

with this one:

      RETURN
SUMX( Tony_data ,
                Intercept + Slope * SELECTEDVALUE ( 'Tony_data'[YEAR])
            )

Btw, this one is the very first reply of mine in this place, so HELLO WORLD then :'>