Networkdays

[bdehning]

I tried using the following but it is one day off due to February 29th this year I beleive.  I got total days of 106 but it should be 107? 

WorkingDaysFriSatHolidays =

VAR _holidays = {DATE(2024, 01, 1), DATE(2024, 01, 15), DATE(2024, 05, 27)}

RETURN NETWORKDAYS(DATE(2024, 01, 1), dt"2024-05-31", 7, _holidays)

What am I missing?  

[Greg_Deckler]

@bdehning Interesting, I'll have to test that. You can always use the old fashioned way: Net Work Days - Microsoft Fabric Community

[Greg_Deckler]

@bdehning OK, did some testing. I believe the issue is that you specified 7 in the third parameter meaning that weekends are Friday and Saturday. 5/31/2024 falls on a Friday. See attached PBIX where I did some tests with 2/29/2024 and then Table2 shows an counter in Column 2 for all previous weekdays. It comes out to 109. So that minus 3 is 106

[bdehning]

Greg,   How do I incorporate my Date of Service Filter

Date of Service =

VAR dte =

DATE(

    INT(isiInspections[DateOfService] / 10000)

    , MOD(INT(isiInspections[DateOfService] / 100), 100)

    , MOD(isiInspections[DateOfService], 100)

)

RETURN

IF(

    dte < TODAY()

    , dte

)

So it will control my Card or be a mesure that provides number of working days.

Working Days =

VAR _FirstDate = MIN('VW_DATE_DIM'[Date])

Var _LastDate = MAX('VW_DATE_DIM'[Date])

Var _Holidays =CALCULATETABLE(

        DISTINCT('VW_DATE_DIM'[DATE]),

        'VW_DATE_DIM'[ISHOLIDAY] = 1)

RETURN

NETWORKDAYS(

   _FirstDate,

   _LastDate,

    1,

    _Holidays)

[bdehning]

I got close with, but I am off a few days so something is not counting right.  

Working Days =

VAR _FirstDate = MIN('isiInspections'[Date of Service])

Var _LastDate = MAX('isiInspections'[Date of Service])

Var _Holidays =CALCULATETABLE(

        DISTINCT('isiInspections'[Date of Service]),

        'VW_DATE_DIM'[ISHOLIDAY] = 1)

RETURN

NETWORKDAYS(

   _FirstDate,

   _LastDate,

    1,

    _Holidays)

[Anonymous]

Hi,@bdehning 

Has your problem been solved?

If it is solved, please share your solution, which will allow other community members who have the same problem as you to find a solution faster.

If not, please share the pbix file except for the sensitive data, and then re-describe your needs, such as start and end dates, the days and days of the week you take off as a week, and the days of vacation in between, and what kind of results you expect. We'll be better suited to help you solve your problems.

Best Regards,

Leroy Lu