cancel
Showing results for
Did you mean:
Chalklands Frequent Visitor

## Is there a function for counting work days in a month

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Jeltex Member

## Re: Is there a function for counting work days in a month

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

2 REPLIES 2
Highlighted
Jeltex Member

## Re: Is there a function for counting work days in a month

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 Frequent Visitor

Thanks Jelte.

Pete