cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chalklands Frequent Visitor
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
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:

Capture.PNGResult

Hope this helps!


Kind Regards,

Jelte

2 REPLIES 2
Highlighted
Jeltex Member
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:

Capture.PNGResult

Hope this helps!


Kind Regards,

Jelte

Chalklands Frequent Visitor
Frequent Visitor

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

Thanks Jelte.

 

Pete