Groupby and return values based on another column

I want to return the Value at the max Date for each ID. (then avergage those values)

I am able to return the max Value for each ID, but not the value at the max Date of each ID.

Here is what I have so far:

Average_Max_Day = 
AVERAGEX (
    GROUPBY (
        test_table,
        test_table[ID],
        "max_value", MAXX ( CURRENTGROUP (), test_table[Value] )
    ),
    [max_value]
)

For those familiar with python, I can achieve the desired results with this code:

import pandas as pd
df = pd.read_excel("test.xlsx",usecols=['ID','Date','Value'])
df_grouped = df.loc[df.groupby(['ID'])['Date'].idxmax()]
df_average = df['Value'].mean()