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:

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)

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

Its syntax is simple, like this:

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)

Tutorials