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

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