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)