Forum Discussion
In-Transit Material
Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
It may may sense to merge your two fact tables if possible.
Hello Greg_Deckler
I mocked up a sample of the same scenario I am trying to do. I need to know the Quantity of what Shipped before my slicer's Month-Ending date, but was receipts After that date.
I made an adjustment to the file, but since the link is to the shared file on my GoogleDrive, you should be able to click that same link before.
I removed the Receipt record of Order 99 so this helps with calculating In-Transit to also include Shipped products that have no receipts recorded yet as well and not just what does have a receipt date that is after the Month-Ending date selected in the slicer.