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 ,
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.