I am having a pain of a time getting a result that works for In-Transit products when I am viewing my Inventory Snap Shots for Month-Endings. Below are what I believe would be sufficient examples of Tables being used for this calculations.
I am using a Slicer to select the Month-Ending Dates and I want to know the Shipments in the ShipTable that all shipped = or < (on or before) the selected Month-Ending but the Receipt Dates in the ReceiptTable are > (after) the selected Month-Ending.
I keep trying different things with calculated columns to try and bring over the Receipt Date into the ShipTable and measures using AddColumns, SummarizeColumns, SelectColumns, and maybe some others, but all fail for many different reasons. Can someone please point me in the right direction?