Return Working Days in Power BI using DAX

[@scottstinson9539]

Stubmbled across this video trying to learn Networkdays... leaving with much more. New to DAX and PowerBi. The plain english explaination of the what and why things are has helped more than I can explain. Tell your friends...hard to find good videos like this now days. Always getting buried with crap. EXCELLENT JOB!!!

[@bradj229]

Always great to see Mitchell's DAX videos. Thanks!

[@siddharthakar9369]

He is not Mr. Mitchell anymore, he is Dr. Michell. Thanks Doc you legend.

[@shoaibrehman9988]

Hi Mitchell this is super exciting, pls keep posting videos for DAX . Thanks for sharing with us.

[@pthapa55]

Awesome example. This really helps. Thank you for bringing to us.

[@shubhabratadey]

Awesome video. Simple and very useful

[@jodyswanson7197]

Hi Mitchell, your videos are very helpful. Thank you! How could you write this to exclude a 3-day weekend (Fri, Sat, and Sun) and holidays? We work from Monday thru Thursday.

[@arne.munther]

I made a table with holidays for like then years or more. Holidays names in rows, years as coloumns. That way you can see, the input and easy change it. Very convenient this year, we just lost one holiday from next year :( I used power query to import it.

[@pedrojosilva]

Hi , it's possible to combine this measure with sum? I want to sum values excluding weekends.

[@metalrouge2648]

O.o, that made my calculation easier . Thabks.

[@SiriusScientist]

This is great! How would you modify to recognize “country” so you can vary the recognized holidays or work days by region?

[@siddharthakar9369]

Hey, that’s a good question! You can create a table with Country and HolidayDate, then use the FILTER function in your DAX formula. Add a country slicer and use SELECTEDVALUE to get the holidays for that country. The formula might look like this: Working Days = VAR _FirstDate = MIN('Date'[Date]) VAR _LastDate = MAX('Date'[Date]) VAR SelectedCountry = SELECTEDVALUE('CountryTable'[Country]) RETURN NETWORKDAYS(_FirstDate, _LastDate, FILTER(Holidays, Holidays[Country] = SelectedCountry))

[@SiriusScientist]

@@siddharthakar9369 thanks!

[@CaitlinOuellette]

Love it! Thanks.

[@siddharthakar9369]

how did you created or compared the list of holidays ??

[@stoneage8810]

the holiday count part, are DISTINCT and VALUES the same in this case?

[@nariroeplal1553]

Hi could you show the tutorial on how you created true false dax for holidays?

[@jyotideokar9457]

Hi, I want to calculate 7 th working day of next month of given month. For example if my given month is jan 24, I need 7 th working day of Feb'24. Non working days are Saturday and Sunday. But it would be great if we add list of holidays. I tried a lot but no luck. Please help