Network Days in DAX

[i820017]

I am trying to do the equivalent of Network Days in excel as a DAX measure.

The table is 'Procedure Request Form', and I want to do the calculation 'Hold_End_Date' - 'Hold Start Date' that removes all weekends. Both 'Hold_End_Date' and 'Hold Start Date' are columns.

Can this be done as a measure? If so, how?

And if this cannot be done as a measure, how would it be done as a calculated column?

[i820017]

This thread helped me get the answer...thanks!!

[i820017]

This is the calculated column that I am using, and it is not working. 

Any idea why?

[Arul · Accepted solution]

@i820017 ,

I hope below thread would help you to get your output.

https://community.powerbi.com/t5/Desktop/Network-days-excluding-weekends-and-holidays-calendar/m-p/1... 

Thanks,

Arul