Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

First Interaction after Campaign Sent

I have 3 tables. The campaign table is connected to the interactions table by the contact table.   Campaign Table   Contact Table   Interaction Table   My current try First...
Need Help
  • amustafa's avatar
    amustafa
    2 years ago

    Hi Anonymous 

     

    You can add a new DAX measure in your Interactions table to get the first date. It is dynamic to what you select in the Matrix.

     

    FirstInteractionDate =
    CALCULATE(
        MIN('Interactions'[Interaction Date]),
        ALLEXCEPT('Interactions', 'Interactions'[MemberNumber], 'Interactions'[Type])
    )
     
    Results:

     

    OR 

     

     

amustafa's avatar
amustafa
Solution Sage
2 years ago

Hi Anonymous 

 

You can add a new DAX measure in your Interactions table to get the first date. It is dynamic to what you select in the Matrix.

 

FirstInteractionDate =
CALCULATE(
    MIN('Interactions'[Interaction Date]),
    ALLEXCEPT('Interactions', 'Interactions'[MemberNumber], 'Interactions'[Type])
)
 
Results:

 

OR