Bring over the Min Date based on filters

[michael_knight]

Hi,

I'm trying to create a custom column which will bring over the Min Date based on filters from another table

Mshp	Meeting Date
1	01/01/2022
1	15/01/2022
1	10/02/2022
2	15/12/2021
2	29/01/2022
3	19/02/2022
4	22/01/2022
5	16/06/2021
5	08/08/2021
5	11/11/2021
5	03/01/2022

From that table above I want to create the below column:

Mshp_ID	Latest Date
1	10/02/2022
2	29/01/2022
3	19/02/2022
4	22/01/2022
5	03/01/2022

I tried to create the column with this DAX but no luck

CALCULATE(
MIN( Meetings[Latest Date]) ,
ALLEXCEPT(Meetings,Meetings[Mshp_ID]) 
)

Any help would be appreciated

Thanks 

[Applicable88 · Accepted solution]

@michael_knight if I understood correctly please try:
Measure=
var  _Filter= Calculate (Min ('Table'[Date]))

Minx( Values(Mshp_ID), _Filter))