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 linestx function using the example file below?

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

 

  • 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

3 Replies

  • 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