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

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 6 members 961 guests
Recent signins: