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 ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.