Counting Number of Working Days

[Johnf78]

Hi All,

I would appreciate some help please.

I need to count the number of working days between a date range. I have created a new Table using 

MyDate = CALENDARAUTO() and have a Visual Slicer to select the date range. I now want to determine the working hours between those dates so that I can calculate my Utilization %.

My expression doesn't work. I have tried a new Measure :

NoOffWorkingHours = COUNTX(MyDate;if(WEEKDAY(MyDate[Date].[Day];2)<6;1;0))*8

It is counting weekend days as well as weekdays.  Anyone that can spot my error?

In essence, how do I count the number of workdays between the date ranges?

[Johnf78 · Accepted solution]

Thanks all,

I manage to solve it by using Sumx in place of Countx

NoOffWorkingHours = SUMX(MyDate;if(WEEKDAY(MyDate[Date].[Day];2)<6;1;0))*8