Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Is that an example of source data?
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |