DIFFERENCE OF DAYS WITH NETWORKDAYS EXCLUDING DUPLICATE VALUES

[Syndicate_Admin]

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 repeated values in column #Guia, that is to say that the last rows of the table should only take me 1 since the rest is repeated as a result of the same case.

# Guide	Start Day	Closing Day
000400006025	13/4/2023	5/5/2023
000400006037	18/4/2023	3/5/2023
000400006048	21/4/2023	5/5/2023
000400006051	21/4/2023	3/5/2023
000400006057	24/4/2023	8/5/2023
000400006064	24/4/2023	3/5/2023
000400006066	26/4/2023	10/5/2023
000400006067	26/4/2023	5/5/2023
000400006068	26/4/2023	9/5/2023
000400006069	26/4/2023	16/5/2023
000400006070	26/4/2023	16/5/2023
000400006082	26/4/2023	15/5/2023
000400006082	26/4/2023	15/5/2023
000400006082	26/4/2023	15/5/2023
000400006082	26/4/2023	15/5/2023
000400006082	26/4/2023	15/5/2023
000400006082	26/4/2023	15/5/2023
000400006082	26/4/2023	15/5/2023

[Syndicate_Admin · Accepted solution]

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_Admin]

It 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.

[amitchandak]

@Syndicate_Admin , Try a measure like

Sumx(summarize(Table, Table[# Guide], Table[Start Day], Table[Closing Day]), networkdays(Table[Start Day], Table[Closing Day], 1))