Forum Discussion
Solved
Container Delivery Date
Hi Team, My query may be a power BI/Query - unsurebest location to keep tracking on multiple delivery dates. I have a daily report from freight forwarding that are uploaded in Power BI and contai...
If yes, you can continue like below:
Latest ETA =
CALCULATE(
MAX('Freight'[ETA Date]),
ALLEXCEPT('Freight', 'Freight'[Container ID])
)First ETA =
CALCULATE(
MIN('Freight'[ETA Date]),
ALLEXCEPT('Freight', 'Freight'[Container ID])
)Delay (days) =
DATEDIFF([First ETA], [Latest ETA], DAY)If this solved your issue, please mark it as the accepted solution. ✅
Hi RDillon-2025 ,
Thank you anilelmastasi for the helpful response!
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.