Forum Discussion

Fighting21's avatar
Fighting21
Frequent Visitor
1 year ago
Solved

Using linest function example

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...
  • shafiz_p's avatar
    shafiz_p
    1 year ago

    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

shafiz_p's avatar
shafiz_p
Super User
1 year ago

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

Fighting21's avatar
Fighting21
Frequent Visitor
1 year ago

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
  • shafiz_p's avatar
    shafiz_p
    Super User
    1 year ago

    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