Forum Discussion
Syndicate_Admin
Administrator
AdministratorDIFFERENCE OF DAYS WITH NETWORKDAYS EXCLUDING DUPLICATE VALUES
NEEHola, guys I am trying to calculate the difference of days between the two dates with Networkdays, however what I am looking for is by means of a formula to calculate the difference excluding the...
Now if I could solve you gave me an idea the formula is like this:
Days of attention test =AVERAGEX(SUMMARIZE(Claims;Claims[Notice];Claims[Claim Start Date];Claims[Claim Closing Date]);NETWORKDAYS(Claims[Claim Start Date];Claims[Claim Closing Date]))
Syndicate_AdminAdministrator
AdministratorIt does not work xq what you are summarizing is the dates and not considering the # of Guia, what I should do is summarize the repeated guides and calculate on the dates that remain.