NETWORKDAYS – number of workdays between two dates (DAX – Power Pivot, Power BI)

The NETWORKDAYS counts the number of workdays between two calendar dates.

Its syntax is simple, like this:

  • Networkdays between = NETWORKDAYS(
        Dates[Start],
        Dates[End],
        1,
        Holidays_table)

Because:

  • First two arguments are start and end of period
  • The third argument is mostly “1”, declaring the typical Saturday and Sunday weekend
  • The fourth argument is mandatory and contains table with days, that should not be counted (holidays)