Number of Working days up to Now

[mrslyfox]

Hi there

How to calculate number of working days for each month of the year, where
the current month have to show number of days between 1st day of month and NOW().
For the working dates I have additional column with indicator of where is working day or not.

[v-jiascu-msft]

Hi @mrslyfox,

How do you want to show them up? As a Calculated column or a measure?

As a Calculated Column, you need a [Month] column:

TotalWorkdayPerMonth =
CALCULATE (
    COUNT ( DateTable[IsWorkday] ),
    FILTER (
        ALLEXCEPT ( 'DateTable', DateTable[Month] ),
        'DateTable'[IsWorkday] = 1
            && 'DateTable'[Date] <= TODAY ()
    )
)

As a measure, we can sum up indicator of workday directly due to it's 0 and 1.

MeasureSumWorkdays =
CALCULATE ( SUM ( DateTable[IsWorkday] ), 'DateTable'[Date] <= TODAY () )

Best Regards!

Dale

[mrslyfox]

Hello @v-jiascu-msft

Please check sample model I have, measure not working as expected.

https://we.tl/JVauvk4B5P

[v-jiascu-msft · Accepted solution]

Hi @mrslyfox,

Try this formula please:

MeasureSumWorkdays =
CALCULATE (
    SUM ( 'Calendar'[WorkingDay] ),
    FILTER ( 'Calendar', 'Calendar'[LINK_Date] <= TODAY () )
)

Best Regards!

Dale