cancel
Showing results for
Did you mean:
Highlighted
SJ_PPM 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.
SJ_PPM 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