Good morning

is this what you needed

i used this to determine the min date by contractor/project

then this for date difference

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Your welcome

It is easy to thing of an LOD as an aggregate but actually it is not - it creates another level that can be further aggregated -

so you can think of it like moving all the potential calculations - date, conditional, another LOD or table calculations - to a higher level (aggregated) in the data structure

Glad to help out

Jim