Negative Net Work Days

[Anonymous]

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"

[amitchandak]

@Anonymous , refer to 2nd page(working day diff) -https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

If that can help .