Fulfilling Quantity ordered according to Quantity stocked

[y5famfnatudu]

Hello,

My question is about how to calculate remaining Quantity in stock & at the same time calculate the orders that can be fulfilled.

Note: kindly note that calculated tables or calculated columns are not allowed for me.

Here's the scenario (data and sample pbix will be attached):

This is how my current data looks like

And this is how I would like to have the table afterwards:

1. Table is sorted by customer, but it can be sorted by any other field (date of order for example)
2. What's happening here is that the first order is compared to the Quantity Stocked, if it can be fulfilled, then show Yes. Then move to the next, and so on.
3. There are 2 scenarios here (shown in the table above in yellow)
   1. if the next order cannot be fulfilled, then move to the next and check and keep calculating the Remaining Stock till no more orders can be fulfilled.
   2. if the next order cannot be fulfilled, then stop, no more calculations are needed.

data and pbix file 

I really would appreciate it so much if you can help me here.

Best regards,

Simon