Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @GenericUser1,
From your description, you could refer to below link:
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
Hi @GenericUser1,
From your description, you could refer to below link:
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
Might have to use multiple calculated columns or measured for this 😕 the hours have to also exclude hours in the weekend
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |