Syntax
NETWORKDAYS is now available in Power BI!! (June 2022), let me show you how it works!
Tutorial with example
Links to the mentioned resources
To get the files:
1. Go to Curbal Download Center > Community Downloads
2. Get File #216
Tutorial when you calculate it manually
In today’s video, I will show you how to calculate NETWORKDAYS using DAX.
Links to the mentioned resources
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #47
Remarks
N/A
Was this helpful?
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