Forum Discussion

Chalklands's avatar
Chalklands
Icon for Helper I rankHelper I
7 years ago
Solved

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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