Forum Discussion

pocquet's avatar
pocquet
Regular Visitor
6 years ago
Solved

Line graph Forecasting

Hi All,   I have generated a forecast using the line graph method, of which I am happy with.   This forecast shows demand in hours, out for the next 2 months based on 2 years of data.   This co...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi pocquet,

    >>is it possible to recreate that forecast value somehow so I can generate my own forecast rather than relying on the one generated by Power BI?

    Yes, it is possible to create the forecast value based on current value.
    You can write formulas to calculate YOY or MOM change rates, then you cna use these rate with current value to calculate out the 'forecast' value of the coming date.

    BTW, if you are familiar with R or Python script. You can also create R/python visuals to coding formula invoke their forecast libraries to get the forecast values based on current table records.

    Regards,

    Xiaoxin Sheng

pocquet's avatar
pocquet
Regular Visitor
6 years ago

Hi Anonymous 

 

Thanks for that, yeah that's exactly what I want to do.

 

is it possible to recreate that forecast value somehow so I can generate my own forecast rather than relying on the one generated by Power BI?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi pocquet,

>>is it possible to recreate that forecast value somehow so I can generate my own forecast rather than relying on the one generated by Power BI?

Yes, it is possible to create the forecast value based on current value.
You can write formulas to calculate YOY or MOM change rates, then you cna use these rate with current value to calculate out the 'forecast' value of the coming date.

BTW, if you are familiar with R or Python script. You can also create R/python visuals to coding formula invoke their forecast libraries to get the forecast values based on current table records.

Regards,

Xiaoxin Sheng