Forum Discussion
Karthik_Ram
5 years agoHelper II
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 month over the last 2 years.
So if we are in month of May i need to forecast for rest of year. And when we roll over to Jan 2022 it will be for whole year except Jan
Thanks
14 Replies
- Ashish_MathurSuper User
Hi,
Share some data and show the expected result in a simple Table format.
- Karthik_RamHelper II
Let me know if this helps
- Ashish_MathurSuper User
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.