Net Work Days
Recreates the NETWORKDAYS function from Excel with some bonus measures and one that needs fixed or demonstrates a bug/documentation glitch.
NetWorkDays calculates the number of days between two...
Very nice scripts, but what if I want to aggregate the network days by another column from the NetWorkDays table?
Eg. if I add a "Name" column to the NetWorkDays table and add John and Jane Doe and one more row:
When using the NetWorkDays measure it works on a row by row level, but if I try to aggregate by the 'Name' column the measure seems to be incorrect:
Any idea why and how to fix it?
I have included the modified PBIX file.