Forum Discussion
forecasting scenarios based on initial numbers
I need to create a forecast based on a set of initial numbers that will be pulled auotmatically from a data source. this is what my initial data looks like Year (current Total Products G...
lbendlin
Super User
Super UserIf you use "What-if?" parameters this will take care of the list generation for you. From there it is a relatively simple PRODUCTX.
can you expand on that i'm not sure i understand.
- lbendlin
still dont understand how this can be used to create the forecast.
The example in the article linked looks to assume there is data in a column upon which a calculation can be applied with the parameter.
dont understand how this can be applied to generate rows in a table or be used in a measure that bases its calculation on a previous row.
some sample code would really help.