Forum Discussion
Forecasting DAX
Hi,
In range C31:C37, please use formulas to get those results.
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.
We need to calculate values for May when in may and also End of month values for remaining months in year. So two columns basically. Below is formula
(((2020 %Chg + 2019 %chg)/2)* Total at End of Month last Month) + Total at End of Month last MonthHi,
That's where my struggle is. I cannot write a measure or a calculated column formula to refer to the previous cell but i can possible write a measure if for all forecast months, the input cell is of the last known month i.e. April. So can you think of some mathematical logic to get the result that you have shown in the Excel file by taking the inpu as April?