Скачать или смотреть NETWORKDAYS in Power Query: Custom Function Tutorial

Master the calculation of working days in Power Query with this custom function tutorial! While Excel has NETWORKDAYS, Power Query lacks this capability out of the box. Follow along as I build a flexible M function that calculates business days between any two dates, with clear explanations of each code component.
UPDATE: Since recording the video, I discovered extra edge case that needs handling, updated code posted to GitHub (link below).

🔗 Links:
GitHub: https://github.com/maxanatsko/YouTube...
My Blog and Website: https://maxanatsko.com

🕒 Timestamps:
00:00 – Introduction & challenge overview
00:28 – Dataset walkthrough & function scope
01:10 – Function code breakdown & M language explanation
03:40 – Implementing the function in your dataset
04:17 – Testing & edge case handling
05:57 – Conclusion

🎥 More about Power Query:
SVG visuals in Power BI:    • SVG Visuals in Power BI  
Power BI Tips & Tricks:    • Power BI Tips & Tricks  
APIs in Power BI:    • Working with APIs in Power BI  
Analytics in Power BI:    • Analytics in Power BI  
Deneb in Power BI:    • Deneb Visuals in Power BI  

___
#PowerBI #PowerQuery #MLanguage #CustomFunction #BusinessDays #DataAnalysis #BusinessIntelligence #PowerBITutorial #WorkingDayCalculation #PowerQueryTips