Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Networkdays without Holidays

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?

  • Anonymous's avatar
    Anonymous
    3 years ago

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

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