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 Everyone
I wish to know how we can calculate Running stock column Desire table (see image), In this example I know the current 'Qty On Hand for item 'A' and the Demand per date, I'd like to calculate a measure called Rolling Stock (see image). I've seen other similar posts here but I can't replicate the measures.
The key column between 'Demand' and 'Warehouse' tables is item column. The Demand table is linked to a Calendar table.
I hope you can help.
Thanks in advance
@RayMundo00 , refer my measures using date table
Inventory / OnHand
CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <min,date[date]))) -
CALCULATE(SUM(Table[Sold]),filter(date,date[date] <min,date[date])))
Power BI Inventory On Hand: https://youtu.be/nKbJ9Cpb-Aw
User | Count |
---|---|
84 | |
79 | |
63 | |
62 | |
51 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |