Inventory first in first out

[Cynwaa]

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.

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.

Is it possible to do something similar in Power BI? I have googled a lot but still have no idea how I should start.

Thanks a lot in advance!

[Greg_Deckler]

Is that an example of source data?

[Cynwaa]

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#M26...

Thanks anyway!