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
Highlighted
Super Contributor

## 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
Highlighted
Super Contributor

## 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

Announcements

Power BI Super User, Greg Deckler, explains

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 53 members 1,009 guests
Recent signins: