Minimum Date after date found in column in another table

[Moet18]

Hello power BI community,

I'm looking for a dax formula, that produces the minimum appointment date for a specific contact after the email sent date to that contact. I have highlighted the deiresed result below.

Many thanks

[amitchandak]

@Moet18 , Try a new column in Table 1

minx(filter(Table2, Table1[Contact ID] =table2[Contact ID] && Table1[email Send Date] <table2[Appointment Date]),Table2[Appointment Date])

[wdx223_Daniel]

@Moet18 

if Table A has a one to many relationship with Table B by Contact ID, then the calculated column formula could be =minx(filter(relatedtable(Table B),Table B[Appointment Date]>=Table A[Email sent date]),Table B[Appointment Date])

[Moet18]

Have I posted in the right place.