Forum Discussion

i820017's avatar
i820017
Resolver II
4 years ago
Solved

Network Days in DAX

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?