Duration between two dates multiple rows

[Anonymous]

Hi all, I wonder if someone can please assist.

I have ship visits, and I'm trying to calculate the hours difference between when a ship arrives at anchor (MoveType = Arrive at Anchor) and is assigned a berth (MoveType = Arrival). So I'm wanting to create a separate table viz that rolls up to show one Duration for each visit to measure how long the ship spent at Anchor (the first date when MoveType = Arrive at Anchor) until it was assigned a berth (the last date when MoveType = Arrival)

A few notes:

- Each ship has a unique VisitId.

- There are other MoveTypes, but I only want these two to be included in the calculation.

- I have active date and cargo type filters used on the page

Here is what the table viz looks like as is:

Thanks in advance!

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Date-difference-When-two-dates-in-different-rows-and-columns/m-p/318893#M141881

[Anonymous]

Thank you so much! Perfect. Amended it to fit an existing column that contains an Id field (VisitId), and it works perfectly.