Combine VALUES and FILTER

[Mopadii]

Hi all,

Can you please support with the following DAX.

I try to calculate networking day between 2 dates, excluding holidays and weekend.
My holidays table is multi-dimensional, it covers every countries. I tried this but it is not a valid syntax...

= NETWORDAYS( _startdate, _enddate, 1, VALUES(date, country = "FR"))

Best.

[lbendlin · Accepted solution]

=
NETWORKDAYS (
    _startdate,
    _enddate,
    1,
    DISTINCT (
        SELECTCOLUMNS ( FILTER ( 'Holidays', [country] = "FR"),"Date",[date] ) )
    )
)

[Mopadii]

Just trying your solution and it works well. Little bit tricky but I will remember the tips.

thanks a lot for your help 🙂