Forum Discussion

rsch91's avatar
rsch91
Icon for Helper I rankHelper I
1 year ago
Solved

NETWORKDAYS() not excluding holidays

Hi,    I have the following piece of DAX:   VAR tabel_vakantiedagen = CALCULATETABLE(                                 SELECTCOLUMNS(Dim_Datum, "Feestdag", Dim_Datum[Datum]),                   ...
  • rsch91's avatar
    rsch91
    1 year ago

    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. 

rsch91's avatar
rsch91
Icon for Helper I rankHelper I
1 year ago

Thank you, it doesn't work unfortunately 😞

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
1 year ago

rsch91 Dim_Datum[Datum] is a date column? 

 

BBF

  • rsch91's avatar
    rsch91
    Icon for Helper I rankHelper I
    1 year ago

    It is. And IsFeestdag is a column too. 

    • BeaBF's avatar
      BeaBF
      Icon for Super User rankSuper User
      1 year ago

      rsch91 column ok, but it's date type?

       

      BBF

      • rsch91's avatar
        rsch91
        Icon for Helper I rankHelper I
        1 year ago

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