DAX LOOKUPVALUE with MAX

Hi Anonymous 

Try this for your calculated column in Table2:

LatestResult =
VAR Latest_Time_ =
    CALCULATE (
        MAX ( Table1[Time] ),
        FILTER ( ALL ( Table1[ID] ), Table1[ID] = Table2[ID] )
    )
RETURN
    LOOKUPVALUE (
        Table1[Result],
        Table1[ID], Table2[ID],
        Table1[Time], Latest_Time_
    )

Anonymous ,

You can also create a calculate column in table2 using DAX below:

Latest Result = 
VAR Current_ID = Table2[ID]
VAR Max_Unix_Per_ID = CALCULATE(MAX(Table1[Unix]), FILTER(Table1, Table1[ID] = Current_ID))
RETURN
CALCULATE(MAX(Table1[Result]), FILTER(Table1, Table1[Unix] = Max_Unix_Per_ID))

Community Support Team _ Jimmy Tao

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