Forum Discussion

AgusElvin1408's avatar
AgusElvin1408
New Member
2 years ago

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