Dax Table Summarize using Lookup

IDEAL_Backtest_Details = 
ADDCOLUMNS( 
    SUMMARIZE(Backtest_Details, 
              Backtest_Details[Animals], 
              "Analysis Date",  min(Backtest_Details[Analysis Date])
    )

    , "Final Date", 
            LOOKUPVALUE(Backtest_Details[Final Date], 
                  Backtest_Details[Animals], [Animals],
                  Backtest_Details[Analysis Date],  [Analysis Date])
 )

something like this?

IP: Backtest_Details

OP:

Hi NMOORE 

if you're looking for a calculated table solution, you may try

NewTable =
GENERATE (
VALUES ( 'Table'[Animals] ),
CALCULATETABLE (
TOPN (
1,
SELECTCOLUMNS (
'Table',
"Analysis Date", 'Table'[Analysis Date],
"Finalise Date", 'Table'[Finalise Date]
),
'Table'[Analysis Date], ASC
)
)
)

Thanks alot for this, I was playing around with it for a while trying to do exactly this but just couldnt get there. Much appreciated.