Forum Discussion
Forecasting using DAX
Hi Everyone, could someone help me for get forecasting for the following case. I provide table as well
Case : 1. I have three items, tootbrush, pillow and office desk
2. I have data current stock in January 2024 for three items above
3. I want to get Forecasting in next month, Forecast Feb 24
Forecast Feb 24 : Stock Material in Jan-24 - Target Utilization Feb 24 + Further Arrival Material Feb 24
4. If i want to get forecasting in Mar-24 the equation must be
Forecast Mar 24 : Forecast in Feb-23 - Target Utilization in Mar'24 + Further Arrival Mar 24
5. If i must continue to Apr-24 and go on, then the equation is same as no 4, as example
Forecast in Apr 24 : Forecast in Mar 24 - Target Utilizatoin Apr 24 + Further Arrival Apr 24
Forecast in Mei 24 : Forecast in Apr 24 - Target Utization Mei 24 + Further Arrival Mei 24
Forecast in Jun 24 : Forecast in Mei 24 - Target Utization Jun 24 + Further Arrival Jun 24
The main question is, Could I get syntax for DAX for one column namely FORECAST which accomodating different approach equation for no 3 , no 4 and no 5 above and get result forecasting for next 12 months
3 Replies
- AgusElvin1408New Member
Thanks in advance everyone.
- Aguselvin140887New Member
need help everyone. Please xxx
- Aguselvin140887New Member
any help everyone, please for your help