problem to find duration in days between two dates taking out the days Sundays and holidays

[Syndicate_Admin]

Hello power bi community, I am still a newbie and I am having problems to do the following, I have two columns of two dates one start and one end, I need to get the duration between those two dates but excluding Sundays and holidays, that the value comes out in decimals for example for two days (2.35), This to be able to make operations with the times. I appreciate your prompt help, thank you.

[amitchandak · Accepted solution]

@Syndicate_Admin , You can use DAx function NETWORKDAYS

Blog:

https://amitchandak.medium.com/power-bi-dax-function-networkdays-5c8e4aca38c

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c