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
Karthik_Ram's avatar
Karthik_Ram
Helper II
5 years ago

Do you have dax or calculation in Dax if we do last known month? For instance Two columns one for this month rest of days we can do based off on May 5th value and for Rest of year value we can do using Apr31st value? I can see if it closely matches to my logic calculation or run by users to see if that works.

Ashish_Mathur's avatar
Ashish_Mathur
Super 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
    Helper 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
    Super 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.