Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
In this video , Mitchell Pearson explores how to calculate the number of working days from a date table in Power BI. He demonstrates how to count working days from a date table, including the option to consider basic holidays.
Mitchell explains a basic approach: counting rows in the date table to get the total number of days. This method assumes a well-structured date table.
Mitchell then introduces the "Network Days" function, which offers a more straightforward way to calculate working days and handle holidays. This function requires a start date and an end date, with optional parameters for specifying weekends and holidays.
Mitchell demonstrates the creation of a new measure called "Working Days" using the "Network Days" function.
Mitchell explores the optional "weekend" parameter, allowing customization of which days are considered weekends. By changing this parameter, users can specify different weekend days (e.g., excluding only Sundays).
Mitchell briefly discusses how to handle holidays using the "Network Days" function.
He suggests creating a list of holiday dates to pass as an optional parameter to exclude these dates from the calculation. However, it's more efficient to have a dedicated "is holiday" column in the date table.
Mitchell refers to Microsoft Learn documentation to provide additional insights and details about the "Network Days" function. The video demonstrates that the "Network Days" function simplifies the process of calculating working days and can handle different scenarios involving weekends and holidays.
Overall, this video tutorial explains how to use DAX functions in Power BI to calculate working days efficiently, providing flexibility in defining weekends and handling holidays.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.