NETWORKDAYS() not excluding holidays

[rsch91]

Hi, 

I have the following piece of DAX:

VAR tabel_vakantiedagen = CALCULATETABLE(

                                SELECTCOLUMNS(Dim_Datum, "Feestdag", Dim_Datum[Datum]),

                                Dim_Datum[IsFeestdag] = 1)

RETURN NETWORKDAYS([Datum gereedgemeld], [Datum factuur], 1, tabel_vakantiedagen) - 1

But it's not properly excluding the holidays. How do I bug fix?

[rsch91 · Accepted solution]

Found the solution. It applied the filter context of the table it was in while it had to ignore it. Just added ALL(Dim_Datum[Datum]) and it worked. 

[BeaBF]

@rsch91 Hi! try with:

VAR tabel_vakantiedagen =
CALCULATETABLE(
SELECTCOLUMNS(Dim_Datum, "Datum", Dim_Datum[Datum]), -- Use "Datum" instead of "Feestdag"
Dim_Datum[IsFeestdag] = 1
)

RETURN NETWORKDAYS([Datum gereedgemeld], [Datum factuur], 1, tabel_vakantiedagen) - 1

BBF

[rsch91]

Thank you, it doesn't work unfortunately 😞

[BeaBF]

@rsch91 Dim_Datum[Datum] is a date column? 

BBF

[rsch91]

It is. And IsFeestdag is a column too. 

[BeaBF]

@rsch91 column ok, but it's date type?

BBF

[rsch91]

Datum is a date type. IsFeestdag is a whole number and has two options: 0 and 1 (so boolean). 

[BeaBF]

@rsch91 can you paste some sample data?

BBF

[rsch91]

I don't really know how - my company uses semantic models. Do you have a link to a tutorial or something? Thanks for your help