Solved: Subtract working days

Elie_HUCHET · ‎09-12-2022

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 🙂

Greg_Deckler · ‎09-12-2022

@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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎09-12-2022

@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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...