Forum Discussion

Karthik_Ram's avatar
Karthik_Ram
Helper II
5 years ago

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 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

In range C31:C37, please use formulas to get those results.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      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.

      • Karthik_Ram's avatar
        Karthik_Ram
        Helper II
        5 years ago

        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.