Forum Discussion
Solved
Help with filtering dates
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 cont...
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!!
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!!
Thankyou so much 🙂