Forum Discussion
jak8282
Helper III
Helper IIICount working days excluding Bank holidays
Hi, I have a Calendar table and a complaints table. I am wanting to work out the days between when workday is 1 and bank holiday is 0 - how can I do this - tried a few things but cant seem to g...
jak8282 , You can use networkdays, you can also pass holiday list as table to this function
networkdays([Start Date], [End Date], 1)
refer how to use calendar for holiday
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c
amitchandak
Super User
Super Userjak8282 , You can use networkdays, you can also pass holiday list as table to this function
networkdays([Start Date], [End Date], 1)
refer how to use calendar for holiday
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c