Is there a function for counting work days in a month

[Chalklands]

Hi,

I'm trying to calculate the total number of working days in the current month. Can anybody suggest a measure/function that would do this?

Thanks

Pete

[Anonymous · Accepted solution]

Hi Pete,

You should use the following Dax codes in your date dimension by adding custom columns:

Day of Week = WEEKDAY('Date'[Date];2)

WorkDay = IF(OR('Date'[Day of Week] =6; 'Date'[Day of Week] = 7); "No"; "Yes")

Then you need to create the following measure:

Workdays = CALCULATE(COUNT('Date'[WorkDay]); FILTER('Date'; 'Date'[WorkDay] = "Yes"))

This is the result:

Result

Hope this helps!

Kind Regards,

Jelte

[Chalklands]

Thanks Jelte.

Pete