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...
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.
Greg_Deckler I tried using your formula early on, but it would not allow me since I have some Ship Dates that start before Due Date. The error message said the formula could not allow for that.
Oh, that would be the CALENDAR function. You would just have to create an IF statement to check which date is larger or smaller and then create your CALENDAR appropriately. Like this:
NetWorkDays = VAR __CreatedDate = MAX(NetWorkDays[created date]) VAR __ReviewDate= MAX(NetworkDays[review date]) VAR Calendar1 = IF( __CreatedDate < __ReviewDate, CALENDAR(__CreatedDate,__ReviewDate), CALENDAR(__ReviewDate,__CreatedDate), ) VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2)) RETURN COUNTX(FILTER(Calendar2,[WeekDay]<6),[Date])Hi Greg_Deckler , Getting the attached error while using IF Condition. Kindly assist.
