PorcuBI

Power BI Networkdays DAX​

CALCULATE WORKING DAYS USING DAX (NETWORKDAYS)​

In 2022, Microsoft introduced the DAX function NETWORKDAYS, which provides a simple solution for calculating working days.

Moreover, this tool becomes especially useful when you need to track workdays, plan projects, or calculate time-sensitive metrics while excluding non-working days. As a result, it streamlines processes and saves valuable time.

Networkdays DAX Power BI
Example NETWORKDAYS DAX function

How to use the NETWORKDAYS DAX function?

				
					Weekend On Sat/Sun=
        NETWORKDAYS (
               DATE( Begin Date ),
               DATE ( End Date ),
               1, //indicating the weekend
               { DATE ( holiday ) } ) //optional for holidays
                )
				
			
Networkdays DAX Power BI

Try Networkdays in DAX yourself!

The 1 in the DAX above indicates that the weekend is Saturday and Sunday. If your weekend is on another day, pick one of the other options.

For example, if you have a weekend on Tuesday and Wednesday, you would pick 4 to indicate the weekend.

You can also hardcode the beginning and end date for the calculation (like in the first picture), but you can also pick a flexible start and end date from your data.

Read more about Networkdays in the official Microsoft documentation.

				
					Numbers that indicate the weekend

1 or omitted: Saturday, Sunday
2: Sunday, Monday
3: Monday, Tuesday
4: Tuesday, Wednesday
5: Wednesday, Thursday
6: Thursday, Friday
7: Friday, Saturday
11: Sunday only
12: Monday only
13: Tuesday only
14: Wednesday only
15: Thursday only
16: Friday only
17: Saturday only
				
			
Scroll to Top