Forum Discussion

wynhodgkiss's avatar
wynhodgkiss
Advocate II
1 year ago
Solved

performance against forecast

hi all, I'm using the built in forecasting tool and wondering if anyone knows a way to keep the forecast values while also displaying the actuals? As it is currently my February forecast will dissap...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi wynhodgkiss , hello lbendlin, thank you for your prompt reply!

    As lbendlin mentioned, the built-in forecasting tool will not meet your requirements.

     

    As a workaround, you can use the Remaining Forecast method described in the article below:

     

    Showing actuals and forecasts in the same chart with Power BI - SQLBI

     

    Best regards,

    Joyce

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi wynhodgkiss , hello lbendlin, thank you for your prompt reply!

As lbendlin mentioned, the built-in forecasting tool will not meet your requirements.

 

As a workaround, you can use the Remaining Forecast method described in the article below:

 

Showing actuals and forecasts in the same chart with Power BI - SQLBI

 

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.