Anyone know how to count the number of hours responded to within business hours?

[GenericUser1]

Example: Helpdesk has a limited amount of hours before they have to actually respond to a customer, otherwise they'd have to pay the customer if that condition of hours is not met. The things is, only business hours count, which are 9 am to 5pm. So if I client called at 6pm and helpdesk responds at 9am, the hours between 6pm and 9am don't count towards the conditioned hours. The number of the conditioned hours are only counted within business hours.

anyone know how to do this? lol. I'm guessing some sort of filtering but I'm not very good with structuring my dax

[v-danhe-msft · Accepted solution]

Hi @GenericUser1,

From your description, you could refer to below link:

https://community.powerbi.com/t5/Desktop/Calculate-Time-Difference-with-Odd-Working-Hours/td-p/49052...

And if it could not solve your problem, could you please offer me some sample data and post your desired result if possible?

Regards,

Daniel He

[GenericUser1]

Might have to use multiple calculated columns or measured for this 😕 the hours have to also exclude hours in the weekend