Syntax
Function not available in DAX, but it can be replicated, check video below.
Tutorial with example
In today’s video, I will show you how to calculate Networkdays using DAX.
Download example file:
The file is available for download here.
Remarks
N/A
Hi Ruth,
Any response would be highly appreciated.
Thanks in advance!
Hi Ruth,
Thank you for all of the amazing videos and great ideas. I am currently working on a project that requires to calculate the SLA (Service Level Agreement) date calculated from a specific date. E.g. If I receive a task today, then it will have to be delivered within 5 networking days.
If today is 03/26/2018, then + 5 networking days (excluding weekends and holidays) would be 04/02/2018. If one of the working days is a holiday, then the SLA date would be 04/03/2018. So I am trying to calculate this using your networkdays example but with no success at this moment. Any ideas would be highly appreciated.
Thanks again for your fantastic videos.
Greetings 🙂
Steve
WOW Ruth, you are amazing! Thanks x1000:)
Hi Ruth, I love your videos. Could you please fix the link to the example file. When I click on the link, I get the file for #49 not for #47. Thanks so much, and HAPPY HOLIDAYS!
Hi Steve,
Me and my links… Here is the correct one:
http://gofile.me/2kEOD/IeH2lYUlp
/Ruth