Forum Discussion

Witold's avatar
Witold
Frequent Visitor
4 years ago

"Dynamic" ajustable forecasting

Hi, I looking for way to make a great forecast of sales which is based on expenses (with the possibility to adjusting by "what if").

 

That what I'm looking for is 

 

1. Best forecast tool that would show me not only a forecast as the one in visual settings, but forecast could be:

- used with other dimensions

- could be adjustable by changing based values, for example, expanses

- be marked as forecast but also, have info about the accuracy of the forecast by showing the gap between real data (by the time) and forecasting one. 

 

2. A way to change forecast by "what if" funcion, including changing expances and ajust sales or promotions in selected data 

 

do you know some good tools to recive it or even some guides for it? 

 

2 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support

    Hi, Witold 

    If you have time data in your data source, maybe you can use the forecasting feature in PowerBI 'Analytics pane'.

    Apply forecasting 

     

    Best Regards,
    Community Support Team _ Eason

    • Witold's avatar
      Witold
      Frequent Visitor

      Hey, I try it as a first solution, unfortunately, it does not meet my expectations, it's impossible to drill down/drill-up. I cant work with this, it's impossible to convert that into the real dimension, and hence I cant put a for example percentage growth of forecast in case of... sometinhg.  Looking for other solutions