Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DATEDIFF without weekends still doesn't work...

Hello everyone,   I have read a lot of solutions about how to exlude weekends in a datediff formula, but i did not work for me. My formula is: IF([Order uitgewerkt] = "Yes", IF( DATEDIFF([Orde...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , If you these two columns in one table and you date table with workday(1/0)

A new column =

sumx(filter('Date', 'Date'[Date] >= Table[Start engineering] && 'Date'[Date] >= Table[Engineering ready]),[Work Day])

 

Refer to file below, Where on 2nd page work day diff as measure form 2 tables. But same is true for one able

 

Also discussed it here, if this can help: How to calculate Business Days/ Workdays, with or without date table: https://youtu.be/Qv4wT8_P-AA