Forum Discussion

RDillon-2025's avatar
RDillon-2025
New Member
1 year ago
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...
Tutorial Requests
  • anilelmastasi's avatar
    anilelmastasi
    1 year ago

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.