Dax to count working days per month (Saturday & Sundays is week off)

[Hamdan1234]

How to calculate Dax to count working days per month (Saturday & Sundays is week off). Need urgent help.

[PhilipTreacy · Accepted solution]

Hi @Hamdan1234 

To count working days you can use a Date Table that contains a column that indicates if a date is a working day or not.  You then count the workign days between 2 dates, see this articlke for code and explanation

Counting working days in DAX - SQLBI

You question isn't clear on how you want to calculate the amount of working days.  You've supplied an image of a table of data so are you hoping to calculate working days between 2 specific dates related to that data, or do you just want to know the number of working days in each month?

Regards

Phil