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 can anyone suggest a similar model example that could be used as a query coding under Excel or Power BI.

 

The expected outcome is to generate a table that each with sales record with related cost using the FIFO calculation.

 

Thanks.