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

anilelmastasi's avatar
anilelmastasi
Icon for Super User rankSuper User
1 year ago

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's avatar
anilelmastasi
Icon for Super User rankSuper User
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. ✅