Get the most recent transaction date

Hi, Please check the below picture and the attached pbix file.

It is for creating a new table.

Expected table = 
VAR _expectedresulttable =
    CALCULATETABLE (
        Data,
        FILTER (
            VALUES ( Data[Item ID] ),
            CALCULATE ( ABS ( SUM ( Data[Qty. in WH] ) ) ) = 0
        )
    )
VAR _groupbylatestdate =
    GROUPBY (
        _expectedresulttable,
        Data[Item ID],
        "@latestdate", MAXX ( CURRENTGROUP (), Data[Date Last Trans.] )
    )
RETURN
    CALCULATETABLE (
        Data,
        TREATAS ( _groupbylatestdate, Data[Item ID], Data[Date Last Trans.] )
    )

Thanks a lot, it did the work!