Allocation of total production against open orders across multiple rows

[praveenp2741147]

I am trying to allocate total production against multiple open orders of a particular commodity in MS Excel using power query. I could do the same using SUMIFS formula in Excel but struggling to make it happen using power query. I have attached link to a sample of how order book looks and the production data that needs to be updated in FIFO against each order constrained by its order quantity. For eg. If total production of 4 has happened for a particular item against Order1 of 2 units and Order2 of 8 units, then first 2 units production to be allocated against Order1 and remaining 2 to be updated against Order2
Kindly help
Link to sample order book and production to be considered.

study Order allocation.xlsx

drive.google.com