Forum Discussion
Creating a shipping schedule with on going date range changes
Hi Anonymous ,
Do you want to get the max outbound per day or per month? Based on your description, I think you want to monitor daily shipments. For the sample data , the data is shown with per month. For the separate files, you could append them into one table and the result will not be affected when calculate.
You could post your expected result that will make us understand clearly. And I created a sample which is appended queries and show the max bound for per location.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you v-xuding-msft for posting a reply and offering guidance
I would want to monitor daily outbound.
It looks like from your attached sample that you posted Max Outbound for each location in their latest month (December) Please correct me if I read it wrong.
Using your sample table, could I just create a slicer/drop down menu to show multiple months or only current month at a time? If that was the case, I think if I could show a actual shipment counts in a line clustered chart where the bars would be the predetermined inbound/outbound numbers and my line would be what the actual inbound/outbound numbers were.
Attached is a visual of what I tried to describe above( Profit in the graph would be my actual and Rainy Days would be the preset min/max set numbers). If it would be easier to flip them, that is completely fine too.