Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have service desk tickets and I want to calculate the total time it took to close the tickets. I only want to consider the business hours.
Based on the country the public holiday should be also taken into account.
Can someone help me with the approach?
Hello @DiKi-I ,
Check if this helps in your case https://youtu.be/6JA6uy3ZRBA?si=jVEPCgtLAldkQo26
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!