Inventory first in first out

Question

the task: I have a set of data with the information of the move in dates and move out dates of production batches, and I need to check which batches violate the "first in first out" rule. And it should be on plant and product level.&nbsp;In excel, I would make a pivot table and order the move in dates from oldest to newest, and then I can just compare the move out dates.&nbsp;&nbsp;Is it possible to do something similar in Power BI? I have googled a lot but still have no idea how I should start.&nbsp;Thanks a lot in advance!

greg_deckler · Answer

Is that an example of source data?

anonymous · Answer

hi Greg_Deckler,thank you for your reply,I accidently posted the question again in a new article and I found the solution there: https://community.powerbi.com/t5/Desktop/Inventory-first-in-first-out/m-p/565566/highlight/false#M266895&nbsp;Thanks anyway!

Forum Discussion

Inventory first in first out

2 Replies

Related content

Inventory and Stock balance calculation

Inventory Forecast

Inventory Management Dashboard

Inventory opening closing

Inventory Management Dashboard