cancel
Showing results for
Did you mean:
Frequent Visitor

## Calculating Number of Workdays for Each Month per day

Hi,

I have managed to calculate if the day is a working day or not, but I need another column for each transaction to show the number of working days. Instead of '1', I need it to calculate it as 23. For Example, 15th January 2018 in one column and the another column 23

Any help will be greatly appreciated.

SJ

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Calculating Number of Workdays for Each Month per day

Hi @SJ_PPM,

Calculated column.

`WorkingDay = IF(WEEKDAY('Date table'[Date],2)<=5,1,0)`

Measure.

```count workingdays =
CALCULATE (
SUM ( 'Date table'[WorkingDay] ),
ALLEXCEPT (
'Date table',
'Date table'[Date].[Year],
'Date table'[Date].[Month]
)
)```

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team

## Re: Calculating Number of Workdays for Each Month per day

Hi @SJ_PPM,

Calculated column.

`WorkingDay = IF(WEEKDAY('Date table'[Date],2)<=5,1,0)`

Measure.

```count workingdays =
CALCULATE (
SUM ( 'Date table'[WorkingDay] ),
ALLEXCEPT (
'Date table',
'Date table'[Date].[Year],
'Date table'[Date].[Month]
)
)```

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: Calculating Number of Workdays for Each Month per day

Thank you very much! That is exactly what I needed!

Thank you,

SJ