last visit

Hi mrpowrbihelp

Use this Measure to get Last Item Carried

Last_Item_Carried =
LASTNONBLANK (
    CALCULATETABLE (
        ALL ( Table1[Items Carried] ),
        FILTER ( Table1, Table1[Account #] = SELECTEDVALUE ( Table1[Account #] ) )
    ),
    CALCULATE ( VALUES ( Table1[Items Carried] ) )
)

HI mrpowrbihelp

These MEASURES to get the LAST VISIT DATE and the RELATED CONTACT NAME

Last_Visit_Date =
MAX ( Table1[Visit Date ] )

Last_Contact_Name =
CALCULATE (
    SELECTEDVALUE ( Table1[Contact Name] ),
    FILTER (
        ALL ( Table1 ),
        Table1[Account #] = SELECTEDVALUE ( Table1[Account #] )
            && Table1[Visit Date ] = MAX ( Table1[Visit Date ] )
    )
)

Hi mrpowrbihelp

See the File attached here as well