topic Minimum Date after date found in column in another table in DAX Commands and Tips

Minimum Date after date found in column in another table

Moet18 — Thu, 17 Sep 2020 10:11:46 GMT

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

Re: Minimum Date after date found in column in another table

Moet18 — Sun, 20 Sep 2020 09:13:54 GMT

Have I posted in the right place.

Re: Minimum Date after date found in column in another table

wdx223_Daniel — Tue, 03 Nov 2020 00:36:51 GMT

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])

Re: Minimum Date after date found in column in another table

amitchandak — Tue, 03 Nov 2020 02:30:50 GMT

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])