Hello all, I’m not sure why I can’t get this right - perhaps it’s my migraine…
During the recent quarantine situation, we had to change a lot of our customer’s deliveries over to a commercial delivery option. Now I have been asked to build a report that shows the sales that moved from a given group of truck routes over to the commercial delivery.
Example - if customer ABC was getting delivery from Truck 01 anywhere in the period of January - April (dates and trucks filtered by slicer on the page), then my sales for Truck 01 needs to be the total sales for customer ABC.
And, of course, I need this to be a total amount, not showing the customers because of the number of customers returned for each truck.
I have attached a simplified PBIX example. I keep thinking my answer here is CALCULATETABLE - but I just can’t get it to work. And (of course) most CALCULATETABLE examples are involving dates, not trucks Any help is welcome
Evaluate Prior Shipping.pbix (73.3 KB)