Dax Network Days

[richrich123]

Hello,

Could someone point out where I have gone wrong here. I have 'days since last update' which gives me actual days between A and B but I want to also have working days to exlude weekends. I have used NETWORKDAYS to count the working days (Mon-Fri).

count_workingdays = NETWORKDAYS('Case'[lastcustomerupdate].[Date], TODAY(),1)

It only seems to be deducting 1 day for a weekend rather than 2?

[Padycosmos · Accepted solution]

The Networkdays() counts both the start and end days, if they are working days and the calculation is correct. If you want to exclude the start date , use start date+1 or if you want to exclude today, use today()-1 as the end date

Hope this helps

[richrich123]

@Padycosmos fantastic, that has sorted it, I had realised it was including the first day. Thanks!