topic Networkdays in DAX Commands and Tips

Networkdays

bdehning — Tue, 25 Jun 2024 18:02:35 GMT

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?

Re: Networkdays

Greg_Deckler — Tue, 25 Jun 2024 18:28:41 GMT

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

Re: Networkdays

Greg_Deckler — Tue, 25 Jun 2024 18:42:46 GMT

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

Re: Networkdays

bdehning — Wed, 26 Jun 2024 01:44:08 GMT

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,

_Holidays)

Re: Networkdays

bdehning — Wed, 26 Jun 2024 04:28:50 GMT

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,

_Holidays)

Re: Networkdays

Anonymous — Mon, 01 Jul 2024 06:43:12 GMT

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