Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys, new to DAX and I was wondering if you could help me with a formula.
I have the following table and a measure called Stock Value which is lets say 420,000
Projected Sales Start of Week
1850 16/10/2023
2200 23/10/2023
3300 30/10/2023
4400 6/11/2023
I want to create a formula that would return me the number of weeks where the stock value is less than the cummulative sum of sales with the current week being the first week.
Basically the weeks of cover based on the forecasted sales.
Any ideas on how to achieve this will be highly appreciated. Thank you
Solved! Go to Solution.
@Blaise880 I did something very similar to this, see if this helps: Days of Supply - Microsoft Fabric Community
@Blaise880 I did something very similar to this, see if this helps: Days of Supply - Microsoft Fabric Community
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
52 | |
27 | |
24 | |
13 | |
9 |
User | Count |
---|---|
74 | |
58 | |
47 | |
16 | |
12 |