Identify non duplicates, to remove, and then calculate time spend on two steps, and average as well

[BrianJ]

@Jetuke_ES,

It is absolutely inexplicable to me that DAX still does not include a NETWORKDAYS function. Until it does, check out the following thread for how to mimic that capability using a custom function within your date table:

Great Tip - NETWORKDAYS Custom Function in Power Query

There have been a lot of questions on the forum lately about the best way to calculate number of workdays not including holidays between two dates. Most of the discussion has focused on DAX-based solutions. This is totally doable via DAX, but as you’ve seen from the recent threads not particularly simple. Well, a much easier solution came out recently in the BIccountant blog: This article provides the Power Query code (attached below for convenience) for a custom function that calculates n…

• Brian