Forum Discussion
HELP WITH A DAX
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.
1 Reply
- v-zhangti
Community Support
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.