Good afternoon!
I'm trying to calculate net work days for my company. I was using a DAX syntax to calculate it, however we do accept NEGATIVE networkdays at our office and the DAX is rejecting the negative numbers. Does anyone have a solution to calculate a networkdays difference that will allow me to have negative?
This was the dax formula I was using
""NetWorkDays =
(Var TBL_Date=CALENDAR('COMPLETED (2)'[BATCH DATE],'COMPLETED (2)'[COMPLETED DATE])
vAR TBL_FinalDate=
ADDCOLUMNS(TBL_date,
"WorkingDay",if(weekday([Date],2)>=6,0,1),
"Holiday",iferror(lookupvalue('MY COMPANY CALENDAR'[Holiday Count],'MY COMPANY CALENDAR'[Holiday Date],[Date]),0)
)
Return
sumx(tbl_finalDate, if([WorkingDay]=1 && [Holiday]=0, 1, 0))""
The error I got was " The start date in Calendar function can not be later than the end date"
