Forum Discussion
Anonymous
3 years agoNot applicable
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?
- Anonymous3 years ago
I took off the 'Bank Holidays' and it worked.
1 Reply
- AnonymousNot applicable
I took off the 'Bank Holidays' and it worked.