Forum Discussion
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 in Power BI?
The expected outcome is to generate a table that each with sales record with related cost using the FIFO calculation.
Thanks.
Hi,
I work out the model!
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:
Hope it could help.
Regards.
5 Replies
I'd be very interesting, I just don't know how I'd do it, it seems pretty complex to me...
Hi,
I work out the model!
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,
We are trying to use your solution with Power Query but in our case, we have multiple products.
Do you have any idea how it could be solved?
Thank you very much.
