Identify non duplicates, to remove, and then calculate time spend on two steps, and average as well

Ok so I’ve been exploring ways to avoid the second Group By operation and succeded :wink: So would you be so kind to test these variatons as well and let me know if performance improved?
Thanks @Jetuke_ES

Now for future reference, this is what I’ve done:

Next I extracted the Min value for [Created On] in two different ways:

Did the same for the Max value for [Completed on] also two approaches:

Here are the updates files. I hope this is helpful.
eDNA - Identify data sets to keep (3b).pbix (44.7 KB)
eDNA - Identify data sets to keep (4b).pbix (40.6 KB)

1 Like