Container Delivery Date

[RDillon-2025]

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 container dates keep changing from time-to-time. How to I set up the ETA Container to show the latest date but also any other previous one that was changed so we know how much delay occured.

How would you recomend to present the multiple changes with ETA?

For example:

Report received on week 1 | Container X  | ETA 01/05/2025

Report received on week 2 | Container X  | ETA 06/05/2025

Report received on week 3 | Container X  | ETA 12/05/2025

[v-pagayam-msft]

Hi @RDillon-2025 ,

As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance. If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.

[v-pagayam-msft]

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.

[v-pagayam-msft]

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.

[anilelmastasi]

Hello @RDillon-2025 ,

In your source, each snapshot of the report should go into Power BI as a separate row, not overwriting the prior one. If you only overwrite, you lose the history. Do your records keep like this or not?

[anilelmastasi · Accepted solution]

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. ✅