I’m seeking your help, please, as I am a little stuck with finding a solution.
In my scenario I have a Case ID, Start date/time and End Date/time per steps to finalize the Case. I need to calculate the elapsed working hours (or minutes) for each Step and also between steps. To add to that Working hours are different dependent on the country (3 variables). I can calculate Workdays elapsed, but cant find a way for hours. I looked at this solution: Calculate the work hours between 2 dates( datetime) excluding weekends - 9 am - 6pm Mon-Fri and couple other solutions online.
But don’t seem to find a way to exclude non working hours by country, and to exclude weekends.
I have attached my working pbix, removed sensitive data, but left my trial dax’es in there.
Elapsed Work Hours Per Step Per Case Sample.pbix (72.3 KB)
Any advice would be really appreciated.
Thank you so much.