Forum Discussion

Karthik_Ram's avatar
Karthik_Ram
Icon for Helper II rankHelper 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
Icon for Super User rankSuper User
5 years ago

Hi,

I do not understand your response.  Perhaps someone else will help you with this.

Karthik_Ram's avatar
Karthik_Ram
Icon for Helper II rankHelper II
5 years ago

Ashish,

Sorry if my earlier response was unclear. 

"i can possible write a measure if for all forecast months, the input cell is of the last known month i.e. April." 

Can you write dax using that assumption you had mentioned in quotes so that I can run by user to see if that is accepted.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    I do not know what growth rate to use month on month.  I need that inout from you.  In an MS Excel file, show the formula assuming the last know month's sales as the input value.