Hello I am trying to see a turn around time from when an email is received to when we reply on it. When I pull the MS outlook exchange data, I see when the email is sent, recieved, but I do not see a date of (if we replied on it). I tried to look by id column but didn't find any relationship between the emails. Any other thoughts?
Solved! Go to Solution.
@jcastr02 - I think you would need to duplicate the original 'Mail' table and then filter the result to ([Folder Path] = "\Sent Items\").
Then you can Merge both tables where you join 'Mail Sent' with 'Mail' on [Id].
@jcastr02 - I was wrong, sorry I didn't test a little more thoroughly. This is actually not as easy as I had thought. You'll actually need to expand [Attributes] to get to [InternetMessageId]. Also in [Attributes] is [InReplyTo] which I'm sure you'll find useful. I chose this sample to show how difficult this may become:
Here are teh queries and the join:
Thanks @ChrisMendoza it looks though as the reply email has the same sent/received date/time as the original email. I am looking for the time the email was replied to (sent back). Any ideas?
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!