topic Re: Using linest function example in DAX Commands and Tips

Using linest function example

Fighting21 — Sat, 02 Nov 2024 03:16:08 GMT

I am learning how to use the linest function. The graph in the photo below is a linest graph I created, but the values seem to be coming out strangely. Can you make one using the linest function or linestx function using the example file below?

https://drive.google.com/file/d/17Ar2TXllzxBGsWMKDi0XRkl_2tDgBIxP/view

Re: Using linest function example

shafiz_p — Sat, 02 Nov 2024 07:25:16 GMT

Hi Fighting21 , Linest or Linestx function is a Least Squares method which basically use to predict what could be the future data. For example, if I have sales data of past year, what could be the sales value of the upcomming year based on the past data.

These function returns table of estimates, which you can use to predict future. For example:

lines = LINEST( 'DataTable'[Value], 'DataTable'[Date] )

This will return a table with many estimator as follows:

You can use Slope and Intercept to establish equation as : Slope * [Value] + Intercept.

Hope this helps!!

If this solved your problem, please accept it as a solution and kudos!!

Best Regards,
Shahariar Hafiz

Re: Using linest function example

Fighting21 — Sat, 02 Nov 2024 11:32:30 GMT

Thank you for your reply thank you very much, but could you know how to wirte [?Value?] in this example file? this is key of my question.

var _slope = SELECTCOLUMNS(ssd,[Slope1])

VAR _interc = SELECTCOLUMNS(ssd,[intercept])

RETURN

[?Value?] * _slope +_interc

Re: Using linest function example

shafiz_p — Sat, 02 Nov 2024 11:44:53 GMT

Want to predict sales for the below five estimated year:

Try code as below:

PredictedValues = VAR Intercept = MAX(PredictedValue[Intercept]) VAR Slope = MAX(PredictedValue[Slope1]) VAR Year = SELECTEDVALUE('Estimated Year'[Est Year]) RETURN Slope * Year + Intercept

Now you can develop visual you want, say line chart:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz