Forum Discussion
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 ...
Hi,
I do not understand your response. Perhaps someone else will help you with this.
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.
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.