Multiple forecasts with Power Query

I recently set up a management accounts model using Power Query to combine multiple forecasts.

This is for a startup charity, where we need the ability to forecast at a high level over a five year period but to be able to update that quickly based on current decisions. We also need to do a detailed six monthly forecast for cash flow purposes. We also want to approve changes on a quarterly basis. Finally, we want to be able to assess the quality of our forecasting so that we can continue to improve it.

Continue reading “Multiple forecasts with Power Query”