Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Im struggling to create DAX measure for a forecasted closing stock position using the start point of the latest stock position, deducting forecasted sales, adding existing open purchase orders and adding forecasted purchase orders to create a forward stock position for each week going forward.
The below Excel example should help to explain:
Solved! Go to Solution.
Worked it out using existing response:
https://community.fabric.microsoft.com/t5/Desktop/closing-stock-calculation/m-p/2607672
Hello!
Adding here some metrics to calculate last stock position value that might be helpful. The [Last Constant Stock] metric can be used in the metric that will do the additions and subtractions with the other forecast metrics.
Sum of Stock Qty = SUM(Table[Stock Qty])
This blog explains the use of the DAX LASTNONBLANK command very well:
DAX LASTDATE vs. LASTNONBLANK | Mitchellsql (mitchellpearson.com)
Worked it out using existing response:
https://community.fabric.microsoft.com/t5/Desktop/closing-stock-calculation/m-p/2607672
User | Count |
---|---|
57 | |
48 | |
18 | |
16 | |
15 |
User | Count |
---|---|
116 | |
42 | |
41 | |
28 | |
21 |