Forum Discussion
Elie_HUCHET
3 years agoHelper III
Subtract working days
Hello,
I wanted to know if there is a formula to calculate the working days between two dates?
For example, if we make a subtraction between Friday September 9th and Monday September 12th. There are 3 days of differences or if we remove the working days there is only one. So I would like to know if there is a formula like in excel.
Thank you 🙂
Elie_HUCHET Yes, there is a new NETWORKDAYS function in DAX now. The old way is here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362#M109
1 Reply
- Greg_DecklerCommunity Champion
Elie_HUCHET Yes, there is a new NETWORKDAYS function in DAX now. The old way is here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362#M109