Power Query - Net working Days in power query
Networking days is easy to do in Excel however in Power Query it's a bit of a different story. In this video i show you how to create your own custom net working days function in power query.
#m #mquery #excel #powerbi #powerbidesktop #dates #data.
So this video contains a bug for the fix to this video refer to (Applied to Hours)
• Power Query - Calculate Net Working Hours !!
New GITHUB File (Based on Working hours video and file)
https://github.com/jbotes/powerbiTuto...
Links
Create a Date List
https://learn.microsoft.com/en-us/pow...
Remove Weekends from Date List
https://learn.microsoft.com/en-us/pow...
Remove Holidays from Date List
https://learn.microsoft.com/en-us/pow...
Count the rows in List
https://learn.microsoft.com/en-us/pow...
Documentation on Duration
https://learn.microsoft.com/en-us/pow...
My site
https://www.basensei.com