Calculating Number of Workdays for Each Month per day

[Anonymous]

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

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

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

[Anonymous]

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

Thank you,

SJ