HELP WITH A DAX

[Syndicate_Admin]

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.

 

[v-zhangti]

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.