Forum Discussion
Forecasting DAX
Hello, We use Line chart with Month in axis and Year in legend and Sales as values. Now I need to do some forecasting logic Logic: prior month sales + average % increase for each forecasted ...
Hi,
I am trying to come up with an Excel formula first which can calculate the figures in range C32:C37 directly from the figure in cell C30 (rather than from the previous cell). In cell C32, i tried this formula
=C30+(C30*(1-(AVERAGE(C18/C19,C6/C7)*AVERAGE(C19/C20,C7/C8))))
but my result is 1047.024 and yours is 1006.548. Can you help me with a formula in range C32:C37 which takes the input from cell C30 (rather than from the previous cell). This will make the DAX formula writing easier/possible.
Ashish,
Check the link again. So sales and forecast are different. So for months thats not yet occured we need to take prior month so for June it would be forecasted May value and for July it will be forecasted June value.