Power Qurey for FIFO Stock Calculation

Hi,

I work out the model!

Workbook Download

The followings are the related references:

Hassan Fazal - FIFO Inventory Valuation in Excel using Data Tables

Power Query: One Route to a Running Total

Brian Grant - Use Function in Power Query

I am not sure about the performance while there are lots of data and there might be some dummy approach to get the value.

Please let me know if you have any improvement.

Hope it will be helpful. :smileyvery-happy:

Hi,

I modified the query for the multiple products case.

Please check the following work book:

Multiple Products Version

Hope it could help.

Regards.