Future Simulation without existing data, based on past data?
I have e.g. turnover data for the last years. The calendar information is hold in a calendar table, going from e.g. 2000 to 2020. I would like to show in a diagram the turnover for the last years by period, AND how the turnover will develop in the next year based on the development of the current year. For the next year I do not have data.
I thought about using the calendar table for the dimension, and splitting the formula at today. For all dates below today I use the information I have, for all future dates, I calculate based on the values of this year. For example turnover growed by 2% from January 2011 to February 2011, by 3% the next month, and so on. So how does it develop for January 2012, based on the turnover in December 2011, growing by the calculated 2%.
When I try that, I am told that there are no information available... Do you have an idea or example for that?
Re: Future Simulation without existing data, based on past data?
I attached an example.
For example I have sales-values for 2011 (and before). I do NOT have any values for 2012. I just generated the calendar-table including 2012.
In the example the upper diagram shows sales for 2011. Based on these values I want something like the lower diagram (created in Excel).
This one contains simulated values for 2012, based on the experience for 2011. e.g. since I know that sales increased by 154,- from dec.2010 to jan.2011, i want to estimate that the value for jan.2012 will be dec.2011 + ( (jan.2011-dec.2010) * (1 + est.plus) ). And so on.