Forum Discussion
Helper IDays between 2 date columns to be calculated but also exclude saturdays and sundays
mitchpj75 , refer to the 2nd page - working day on the attached file after the signature of the blog
https://www.sqlbi.com/articles/counting-working-days-in-dax/
https://curbal.com/blog/glossary/networkdays-dax
Super Usermitchpj75 , refer to the 2nd page - working day on the attached file after the signature of the blog
https://www.sqlbi.com/articles/counting-working-days-in-dax/
https://curbal.com/blog/glossary/networkdays-dax
mitchpj75Thank you for the response! I did look at these as the solution but I still struggled however through further searching I was able to do what I need with the following:
Watched this first - https://www.youtube.com/watch?v=kRACuS4eKWA
Then used the code here to setup the UI and it worked - https://www.thebiccountant.com/2020/02/20/date-networkdays-function-for-power-query-and-power-bi/
All seems overly complicated to work out the number of working days between dates but the solutions worked.