topic Re: NETWORKDAYS() not excluding holidays in DAX Commands and Tips

NETWORKDAYS() not excluding holidays

rsch91 — Thu, 30 Jan 2025 13:01:19 GMT

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?

Re: NETWORKDAYS() not excluding holidays

BeaBF — Thu, 30 Jan 2025 13:14:14 GMT

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

Re: NETWORKDAYS() not excluding holidays

rsch91 — Thu, 30 Jan 2025 13:18:39 GMT

Thank you, it doesn't work unfortunately 😞

Re: NETWORKDAYS() not excluding holidays

BeaBF — Thu, 30 Jan 2025 13:21:46 GMT

rsch91 Dim_Datum[Datum] is a date column?

BBF

Re: NETWORKDAYS() not excluding holidays

rsch91 — Thu, 30 Jan 2025 13:27:09 GMT

It is. And IsFeestdag is a column too.

Re: NETWORKDAYS() not excluding holidays

BeaBF — Thu, 30 Jan 2025 13:29:36 GMT

rsch91 column ok, but it's date type?

BBF

Re: NETWORKDAYS() not excluding holidays

rsch91 — Thu, 30 Jan 2025 13:33:44 GMT

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

Re: NETWORKDAYS() not excluding holidays

BeaBF — Thu, 30 Jan 2025 13:37:37 GMT

rsch91 can you paste some sample data?

BBF

Re: NETWORKDAYS() not excluding holidays

rsch91 — Thu, 30 Jan 2025 13:41:56 GMT

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

Re: NETWORKDAYS() not excluding holidays

rsch91 — Tue, 04 Feb 2025 09:14:56 GMT

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.