Forum Discussion
Custom column ToF
Hi mitchpj75 ,
There is no NETWORKDAYS formula in M language or in DAX however the best M language expert in this community ImkeF create her own formula:
https://www.thebiccountant.com/2020/02/20/date-networkdays-function-for-power-query-and-power-bi/
Just create a blank query and paste the code in that blank query now add a new column referencing that formula.
Check PBIX file attach.
Thank 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.
Hi, mitchpj75
It's not very clear about your problem.
Could you mind providing some sample data and the desired result?So we can help you soon.
Best Regards
Janey Guo
All sorted - thanks for responding though.
Thank 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.