Forecasting using DAX

AgusElvin1408 — Fri, 19 Jan 2024 17:58:19 GMT

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

Re: Forecasting using DAX

AgusElvin1408 — Fri, 19 Jan 2024 18:00:22 GMT

Thanks in advance everyone.

Re: Forecasting using DAX

Aguselvin140887 — Sat, 20 Jan 2024 06:55:09 GMT

need help everyone. Please xxx

Re: Forecasting using DAX

Aguselvin140887 — Sun, 21 Jan 2024 02:21:56 GMT

any help everyone, please for your help

topic Re: Forecasting using DAX in DAX Commands and Tips

Forecasting using DAX

Re: Forecasting using DAX

Re: Forecasting using DAX

Re: Forecasting using DAX