Power Qurey for FIFO Stock Calculation

Hi, Is there anyone who is interested to put the below FIFO calculation example to be run in Power Query? https://gallery.technet.microsoft.com/office/FIFO-calculation-with-36dafa3c Or ca...

DXFinance
8 years ago
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:
DXFinance
8 years ago
Hi,

I modified the query for the multiple products case.

Please check the following work book:
Multiple Products Version

Hope it could help.

Regards.