Help with filtering dates

[uc]

Hello

I have two tables namely Contacts and Sales as shown in the example below. I wanted to create a calculated column (Contact after sales date) in Sales table such that only the immediate contact date after the sales date is pulled for each key as shown below.  Can anyone suggest the code that could be used achieve this please? Thanks in advance. 

Contact Date	Key
01/01/2022	1
16/01/2022	2
08/01/2022	3
29/01/2022	4
15/01/2022	1
02/02/2022	4
19/01/2022	3
30/01/2022	2

Sales Date	Key	Contact after Sales date
09/01/2022	1	15/01/2022
24/01/2022	2	30/01/2022
07/01/2022	3	08/01/2022
28/01/2022	4	29/01/2022

[VahidDM · Accepted solution]

Hi @uc 

Try this code to add a new column with dax:

Contact after Sales date = 
CALCULATE (
    MIN ( Contacts[Contact Date] ),
    Contacts[Contact Date] > EARLIER ( Sales[Sales Date] )
)

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[uc]

Thankyou so much 🙂