How to do it...

To implement this recipe, perform the following steps:

  1. Create a new measure with the following formula:
NetWorkDays = 
VAR __Date1 = MAX('R10_Table'[Created Date])
VAR __Date2 = MAX('R10_Table'[Finished Date])
VAR __Date1a = MINX( { __Date1, __Date2 },[Value])
VAR __Date2a = MAXX( { __Date1, __Date2 },[Value])
VAR __Calendar =
ADDCOLUMNS(
CALENDAR(__Date1a, __Date2a),
"__WeekDay",
WEEKDAY([Date],2)
)
RETURN
COUNTX(
FILTER(
__Calendar,
[__WeekDay] < 6
),
[Date]
)
  1. Place the NetWorkDays measure in the Table visualization created earlier.