Forum Discussion

richrich123's avatar
richrich123
Icon for Helper III rankHelper III
3 years ago
Solved

Dax Network Days

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?
 

 


 

Need Help
  • Padycosmos's avatar
    Padycosmos
    3 years ago

    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

     

2 Replies

  • Padycosmos's avatar
    Padycosmos
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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