Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AgusElvin1408
New Member

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

 

AgusElvin1408_0-1705685879154.png

 

3 REPLIES 3
Aguselvin140887
New Member

any help everyone, please for your help

Aguselvin140887
New Member

need help everyone. Please xxx

AgusElvin1408
New Member

Thanks in advance everyone.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.