cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SJ_PPM Frequent Visitor
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

PowerBI Community.PNGAny help will be greatly appreciated.

SJ

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
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]
    )
)

1.PNG

 

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
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]
    )
)

1.PNG

 

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