From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

NETWORKDAYS DAX function

NETWORKDAYS DAX function - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

NETWORKDAYS DAX function

“

- [Presenter] Let's say we have a timeline of dates and we want to measure the duration between them. One way we can measure the contiguous duration is using the DATEDIFF DAX function with day as the unit of time. However, many organizations calculate durations in terms of workdays, which means we don't include Saturdays or Sundays, for example, in these calculations. One way to remove roughly two out of every seven days from our duration calculations is using the built-in DAX date function NETWORKDAYS to calculate the duration in workdays between two dates. We only need to include inputs for the first two parameters of the NETWORKDAYS function. The third parameter lets us change the weekend schedule. Check out the DAX documentation to see the available options for adjusting the weekend days. The fourth and final parameter and the NETWORKDAYS function is an optional input for the holiday dates that we want to remove from the total in the same wave that it removes weekends. One…

Contents