Counting days between two dates, but wrong answer, when the dates are the same day

[Edvin]

Hello all,

Got a problem. I'm counting days between two dates, I need to count how many network days are between the lowest date and the second to the lowest, grouped by ID.

The example:

ID	Company name	Process	Send date
2415976	JMA	SENT	2020.06.11
2415976	LD	NOT	2020.06.11
2415976	JMA	SENT	2020.07.09
2415976	LD	NOT	2020.07.09
2415976	JMA	SENT	2020.07.10
2415976	LD	DONE	2020.07.10

My measure expression looks like this:

avg(networkdays(aggr(min([Send date]),[ID]),aggr(min([Send date],2),[ID])))

Now, somehow it skips the second date, which is equal to the 1st one '2020.06.11', and brings the result 21, which is between '2020.07.09' and '2020.06.11'

The outcome should look like this:

ID	NetWorkDaysBetween
2415976	0

Thanks for the help!

[Edvin]

Never knew you can accept several answers as solution 🙂