Getting Open Work Days using NETWORKDAYS function

[Anonymous]

Hi all,

I'm trying to calculate the number of open work days for each ticket.

I'm using the following function which gets me everything except it doesn't filter out Public Holidays:

IF(OR('MainTable'[Ignore Open Cases]=TRUE,MainTable[Ignore Incomplete Cases]=TRUE()),MainTable[Days Open],NETWORKDAYS([Created On],RELATED('Date Table'[Due Date])))

I have a 'Holiday' column in my 'Date Table' that has the list of public holidays. How do i add it in to my formula? If i try to insert ',Date Table[Holidays]' - i get the error that ' a single value for column 'holiday' in table 'Date table' cannot be determined.

[amitchandak · Accepted solution]

@Anonymous , How come to the date table has a due date?

On network days simply use a holiday calendar

NETWORKDAYS([Created On],'Table'[Due Date], Summarize(filter(Date, Date[Holiday] =1), Date[Date])  )

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c

https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c

[Anonymous]

The Due Date i have is a calculated one(i.e within 5 Business Days of date created). Ideally should it have it's own table? 

Anyways your solution didn't work but i managed to figure it out by including the following: ,1,VALUES('Date Table'[Holiday]).

I'll mark yours as the solution as it did assist me somewhat. thank you

[DT5577]

can you place the entire line of code.