Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
I need help figuring out if a Dax formula can be created to calculate how many hours it takes for a marketer to start and end a visit and how long it takes to move on to their next visit.
For example
The following screenshot shows that a marketer starts his first visit at 7:44 with "X" client and finishes it at 10:42 (It takes 2 hours and 42 min to complete the visit), then takes 4 min and 6 sec to make his second visit and starts it at 10:46 and ends it at 10:53 and so the process continues successively, how I can create a Dax formula that helps me calculate how many hours it takes for a marketer to complete a visit to a client and how long it takes to move to make their next visit.
Hi, @Syndicate_Admin
Can you use Excel to show the logic of your calculations and the output results you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |