Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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's avatar
    v-zhangti
    Icon for Community Support rankCommunity 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.