Calculate business hours with DAX in Power BI

[rathandallas]

I can't believe this is free...You are truly God sent..

[AWildGenerald]

Thanks for the great walk through, Matt! I've been struggling with a query for exactly the same problem, so you can imagine my relief when I saw your post about this!

[phagostini]

This was such a HUGE help to me! Amazing didactics to explain something that is not simple! Thanks so much Matt! Big shout-out to you!

[sulln]

Like your teaching style!  Good emphasis on process.  I will be watching for more of your material in the future.

[wesfurlong]

Clean code that works well and very clear description! Thank-you!

[PedroHenrique-bpts]

Thankk you, buddy. You have no idea how much you helped me

[สกายกองคํา]

Hi Matt, Thanks for your share. I can learn step by step on the video.

[RodrigoSantos-mzvs]

Hi Matt, how are you?
I hope so, friend.
I'm from Brazil and I'm here to thank you for sharing this solution.
Its teaching methodology is simply fantastic.
Detail by detail, explaining each point of the calculation.
You make a complex problem simple to solve.
Thank you!
Be alright!

[EdHarvey]

thanks for going through this all, as you say it's the process and going through it step by step that makes it work. I had this exact use case and my solution was not as elegant. I think that I'll update mine now!

[yannisastaris]

Amazing !!
I was strunguling on that for so long !!
Huge thanks to you

[danamaglanque]

Thank you so much, Matt! This really made me appreciate DAX more :)

[MichaelGotiashvili]

What a great video and great explanation. Thank you!

[kushalkool]

This video helped me a lot! Thank you so much!

[danielcortes]

Thank you, really detailed explanation.... You got my like and subscription

[deejaylars]

Really happy with this! Works great, thanks!

[chelseacl]

Super helpful, thanks! I was wondering two things. First, would this cause issues due to rounding inconsistencies? I'm getting numbers that are slightly off, like an hour or so. But, it may be due to my second thing: I have some null values for completed times (open tickets), and I think this may be affecting the calc since it won't.. .consider those days, I think? Still trying to figure out exactly what's wrong. I've been considering using minutes instead of hours to have a more generic "time elapsed" thing (my thinking is that this would help with rounding inconsistencies, though this may be incorrect) and then displaying as hours where needed. In addition to figuring out how to incorporate the nulls properly, of course. I'm PRETTY sure those are part of the problem.

[ujjwalrattan]

Im dealing with odd business hours, i.e 5pm to 3am is one business day which makes it complicated. Do you have any thoughts on this?

[ajaaskelainen]

This is big & great insight! Thank you!

[jetuke]

Would it be possible to have Business hours different by Country, how would you amend the Dax for that? Any advice would be great...

[ezazhaider]

Hi, I want this in HH:MM:SS format and I need to visualization in Table Matrix. I've tried it but due to text format of HH:MM:SS I'm unable to do aggregation in Matrix Visualization.