HELP getting Latest Information - Dax Command

[getpho92]

So i'm runing 2 queries 1 with data that is in a staging status, another that is constantly being updated and the name may be different dependent on the most recent transaction. I currently have a formula for this column but it isn't following the latest logic as i want it to. I essentially want a XLOOKUP looking at the most recent transaction. I tried to create the query with Order by but seems like Dax is looking at earliest transaction not top to bottom logic. Here is the coding im using and screenshot of the two tables im looking at:

As you can see Maura is the name i want it to show but it keeps showing Rigoberto instead....

Here is the Dax command for table [name]:

name = CALCULATE(MAX(Query1[name]),FILTER(Query1,Query1[Location]=EARLIEST(Picked[LastCart])))

Here is table Query 1:

Table 2: Picked

[v-jialluo-msft]

^{Hi @getpho92 ,}

^{Please follow these steps:}

^{1.Create a measure to find the latest name}

Lates name =
VAR _location =
    MAX ( 'Table'[Lastcart] )
VAR _time =
    MAXX (
        FILTER ( ALL ( 'Query 1' ), 'Query 1'[Location] = _location ),
        'Query 1'[Time stemp]
    )
VAR _name =
    MAXX (
        FILTER (
            ALL ( 'Query 1' ),
            'Query 1'[Location] = _location
                && 'Query 1'[Time stemp] = _time
        ),
        'Query 1'[name]
    )
RETURN
    _name

^{2.Final output}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[tamerj1]

Hi @getpho92 

please try

name =
MAXX (
    FILTER ( Picked, Picked[LastCart] = Query1[Location] ),
    Picked[Packer Name]
)

[getpho92]

When i attempt to do Picked[LastCart] = Query1[Location] i retrieve an error everytime, is this something wrong with the filtering?