Networkdays

Question

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

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

greg_deckler · Answer

bdehning&nbsp;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 · Answer

Greg,&nbsp; &nbsp;How do I incorporate my Date of Service FilterDate of Service = VAR dte =DATE(&nbsp; &nbsp; INT(isiInspections[DateOfService] / 10000)&nbsp; &nbsp; , MOD(INT(isiInspections[DateOfService] / 100), 100)&nbsp; &nbsp; , MOD(isiInspections[DateOfService], 100))RETURNIF(&nbsp; &nbsp; dte &lt; TODAY()&nbsp; &nbsp; , dte)&nbsp;So it will control my Card or be a mesure that provides number of working days.&nbsp; &nbsp;Working Days =VAR _FirstDate = MIN('VW_DATE_DIM'[Date])Var _LastDate = MAX('VW_DATE_DIM'[Date])Var _Holidays =CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; DISTINCT('VW_DATE_DIM'[DATE]),&nbsp; &nbsp; &nbsp; &nbsp; 'VW_DATE_DIM'[ISHOLIDAY] = 1)RETURNNETWORKDAYS(&nbsp; &nbsp;_FirstDate,&nbsp; &nbsp;_LastDate,&nbsp; &nbsp; 1,&nbsp; &nbsp; _Holidays)&nbsp;&nbsp;

bdehning · Answer

I got close with, but I am off a few days so something is not counting right.&nbsp;&nbsp;Working Days = VAR _FirstDate = MIN('isiInspections'[Date of Service])Var _LastDate = MAX('isiInspections'[Date of Service])Var _Holidays =CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; DISTINCT('isiInspections'[Date of Service]),&nbsp; &nbsp; &nbsp; &nbsp; 'VW_DATE_DIM'[ISHOLIDAY] = 1)RETURNNETWORKDAYS(&nbsp; &nbsp;_FirstDate,&nbsp; &nbsp;_LastDate,&nbsp; &nbsp; 1,&nbsp; &nbsp; _Holidays)

anonymous · Answer

Hi,bdehning&nbsp;
Has your problem been solved?
&nbsp;
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.
&nbsp;
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.
&nbsp;
&nbsp;
Best Regards,
Leroy Lu

Forum Discussion

Networkdays

5 Replies

Related content

NETWORKDAYS() Holiday question

Help with NetworkDays column

Networkdays

NETWORKDAYS() not excluding holidays

Networkdays DAX function