Order Fulfillment

OK, learner03 Here is your file back. Always more interesting working with more life-like data sets than I can easily mock-up on my own. I went with my original FIFO measures here because I ran into some issues with my "improved" FIFO due to partial order fulfillment from bins spanning multiple orders. I left the defaults for this on the interesting case of item 15276. In this case if fulfilling orders from the most stocked bins first, the first order is fulfilled by 2 ULDID's, 875738 and 1196659. The next order is small and it can be fulfilled by the remaining inventory in 1196659 so the next order shows the same two bins. The third order exhausts the inventory in 1196659 and so the remainder comes from 1228007.

So, this was the kind of messy display I was trying to avoid with FIFO 2 measures. But, it gets tricky keeping track of partial order fulfillment, where the current order is actually being fulfilled out of versus previous orders. I'm going to mull over this one and see if I can get a solid solution but my first take on this, my FIFO 2 measures in the original PBIX attached to this Quick Measure Gallery post has some issues dealing with it. My original thought was to get the current locations and the previous locations and do an EXCEPT. Except that if they are the same two bins that fulfill the sum of both orders, well then you get BLANK for the second order. So, back to the drawing board on that one! Could probably minimize this situation by fulfilling orders from the smallest bins first but not a real solution. I'm thinking that I can add a column to the virtual table that flags "partial bin fulfillment" and use that to adjust my locations returned on subsequent orders. I'll post an update here if I get it working but it won't be tonight/today.

Your updated PBIX is attached below where I have implemented the measures with some small tweaks required by your data. Overall, I was pretty happy with how it converted to your data actually, just mainly changing table/column names.