Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi! I have been trying to figure how to get response time from customer emails by our staff.
The problem I am running into is that I cant figure out how to get the calculate time within an email chain with multiple responses. Usinger 'earlier' just calculates it from the first two. I do have my emails ranked.
I want to do this calculation in DAX and not in power query
This is what I have thats just giving me first incoming email and first outbound email:
Solved! Go to Solution.
Ok, I am a bit closer now due to finding this:
I had to make some ammendments, but Its calculating on the incoming email the time til the next outgoing email.
We have auto response on, so I need to find away to mark those and have it skip the auto response
Ok, I am a bit closer now due to finding this:
I had to make some ammendments, but Its calculating on the incoming email the time til the next outgoing email.
We have auto response on, so I need to find away to mark those and have it skip the auto response
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |