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

It does not.  I need to study the formulas in your Excel file and then translate them into the DAX language.  So share the download link of your MS Excel file.

  • 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.