Forum Discussion

danielgajohnson's avatar
danielgajohnson
Icon for Helper II rankHelper II
5 years ago
Solved

Initial Email Response from Exchange Connection

Hi everyone. I am at an organization that's interested in finding out which day of the week people are most likely to respond to our initial outreach emails. We use Office for emails, so the Exchange...
Need Help
  • v-xicai's avatar
    v-xicai
    5 years ago

    Hi danielgajohnson ,

     

    You may create measure like DAX below.

     

    Count of InternetMessageID =
CALCULATE (
    COUNT ( Table1[InternetMessageID] ),
    FILTER (
        Table1,
        Table1[Subject] = MAX ( Table1[ Subject] )
            && Table1[DateTimeSent] <= MAX ( Table1[DateTimeSent] )
    )
)

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
5 years ago

Hi danielgajohnson ,

 

You may create measure like DAX below.

 

Count of InternetMessageID =
CALCULATE (
    COUNT ( Table1[InternetMessageID] ),
    FILTER (
        Table1,
        Table1[Subject] = MAX ( Table1[ Subject] )
            && Table1[DateTimeSent] <= MAX ( Table1[DateTimeSent] )
    )
)

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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