Net Work Days

What if I have some empty fields?

In my query the "review date" for ongoing item is blank. and this measure provide gives me an error.

I don't wan't to filther them out. I still want to show all row in my dashboard.

Thank you in advance.

Regards

Greg_Deckler I am trying to add x number of working days to the create date in order to get the review date. Any ideas how can I do that?

The specific requirement is:

for priority 1 add 5 working days, for P2 add 10 working days for P3&4 add 20 working days.

Thank you

Thanks for your help,

NetWorkDays =
VAR Calendar1 = CALENDAR(MAX(KontElemente[Datum der Besichtigung]);MAX(today())

I didn´d understand the part.

VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2))
RETURN COUNTX(FILTER(Calendar2,[WeekDay]<6),[Date])

Can u help me out?

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.

Hi Greg, i am using a direct query and it throws up an error saying countx is not allowed as part of calculated columns dax expressions on Direct Query Mode.. Please Help!!!!

Is there a way to calculate difference between Today() and a given date?

Based on your "NetWorkDaysHoursMinutes"

I tried using MAX(TODAY()) but it didn't work, I used MIN and MAX.  However, I am getting text (Days Hours Minutes) and cannot change the format to whole number.

This is a great solution. 
just wondering if it is possible to pull this detail from a separate table where we can enter public holidays by year?

VAR Holidays1 = DATATABLE("Date",DATETIME,
    {
        {"12/25/2017 12:00:00 AM"}
    })

for e.g. a table will hold Public holidays like this:

Hi, This is really an amazing post. I need help in ignoring a list of dates in my holiday table. I can see that you have ignored 25th Dec for calculating the network days. But if I have a list of dates in my holiday table how to use that in your code. Please help.

And I just need the count in days only.

Greg_Deckler,

Thanks for these measures...  They have been bery useful.  I have a Holiday Table that has a date column for all of the holidays.  Is there a way to reference that column and have it add the dates to the Holidays1 variable in this  holiday measure:

NetWorkDaysHolidaysDaysHoursMinutes = 
VAR Calendar1 = CALENDAR(MAX(NetWorkDays[created date]),MAX(NetWorkDays[review date]))
//VAR Holidays = DATATABLE("Date",DATETIME,{{}})
VAR Holidays1 = DATATABLE("Date",DATETIME,
    {
        {"12/25/2017 12:00:00 AM"}
    })
VAR Calendar2 = EXCEPT(Calendar1,Holidays1)
VAR Calendar3 = ADDCOLUMNS(Calendar2,"WeekDay",WEEKDAY([Date],2))
RETURN COUNTX(FILTER(Calendar3,[WeekDay]<6),[Date]) & " Days " & 
HOUR(MOD(MAX(NetWorkDays[review date]) - MAX(NetWorkDays[created date]),1)) & " Hours " 
& MINUTE(MOD(MAX(NetWorkDays[review date]) - MAX(NetWorkDays[created date]),1)) & " Minutes"