Power query grouping - conditional to data across several columns??...

Hi
I am rather new to power queries, and so far building my power pivot was going very well. Until I bumped into this -

I have a list of orders with corresponding shipment data (3 columns). Shipment data is received from an external source. Every update will create a new line for the same order number.

for example:

Order.ItemID ETS ETA Vessel name
8753060.11 4/21/2021 5/4/2021 MAERSK BULAN
8753060.11 5/14/2021 6/6/2021 TBN

Challenge is - I need only one line per order, with the latest update which in this case will be ETS ETA and Vessel name from the last row, i.e. latest ETS and ETA dates.
I'm struggling to figure out how to achieve that.

Would appreciate some help!
Thanks
sunnyspirit

The attached workbook is empty. It may have external links. Please provide the source data live in the workbook and attach again. Thanks.

Please update your forum profile - your version is 365, not 2008 (which is just a release number). Thanks.

You have multiple columns of ETA and ETS. Which ones should we be analyzing?

If I understand correctly, then I believe this could be accomplished using relatively simple formulas.
The formulas are applied to columns which have been added to the data table on Sheet1.
The Filter1 column is populated using: =MAXIFS([ETS],[Order.ItemID],[@[Order.ItemID]])=[@ETS]
The Filter2 column is populated using: =AND([@Filter1]=TRUE,COUNTIFS(AD$2:AD2,[@[Order.ItemID]],AM$2:AM2,TRUE)=1)
On Sheet2 the output is displayed using: =IFERROR(INDEX(Table1[Order.ItemID],AGGREGATE(15,6,(ROW(Table1[Order.ItemID])-ROW(Table1[[#Headers],[Order.ItemID]]))/(Table1[[Filter2]:[Filter2]]=TRUE),ROWS($A$1:$A1))),"")
Note that the data table on Sheet1 could be filtered based on the TRUE's in the Filter2 column to display the results shown on Sheet2.
Let us know if you have any questions.