Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
any help everyone, please for your help
need help everyone. Please xxx
Thanks in advance everyone.
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |