NETWORKDAYS inside PowerBI

[raeesgillani]

There are two columns, Void Start and Due Date, I would like to work out the number of working days between the two days.

I've tried to use the following formula shown here (by @Greg_Deckler ), but I can't seem to get it to work.

This is the code for my situation (created it as a measure):

NetWorkDays = 
VAR Calendar1 = CALENDAR(MAX('Voids Data'[Void Start]),MAX('Voids Data'[Due Date (corrected)]))
VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2))
RETURN COUNTX(FILTER(Calendar2,[WeekDay]<6),[Date])

It's accepted by PowerBI, but when I throw it into a table visualisation (this visualisation has two columns, one is void start date, the other is due date), I get the following error:

Please help.

[raeesgillani · Accepted solution]

So I kept playing around with different solutions but the original solution provided by @Greg_Deckler seemed to work once I removed null values from my data and then made the extreme values zero:

VAR Calendar1 = CALENDAR(MIN('Voids Data'[Start]),MIN('Voids Data'[End]))
VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2))
RETURN IF(COUNTX(FILTER(Calendar2,[WeekDay]<6),[Date])>1000,0,COUNTX(FILTER(Calendar2,[WeekDay]<6),[Date]))

[TeigeGao]

Hi raeesgillani,

Could you please tell us if your problem has been solved? If you have any problem, please feel free to tell me.

Best Regards,

Teige

[raeesgillani]

Yes the issue was resolved, thank you for the check 🙂