Networkdays without Holidays

[GJ217]

Hi,

I have the following DAX for Networkdays and the issue is that my calculation in Excel doesn't have Holidays and DAX forces the use of Holidays.

WorkingDaysMeasure = 
VAR AbStartDate = SELECTEDVALUE(SicknessAbsence[AbsenceStartDate])
VAR abEndDate = SELECTEDVALUE(SicknessAbsence[AbsenceEndDate])
RETURN
NETWORKDAYS(AbStartDate,abEndDate,1,'Bank Holidays')

Is there another way to calculate Netwrok Days in DAX  but without Holidays?

[GJ217 · Accepted solution]

I took off the 'Bank Holidays' and it worked.