1 of 1 people found this helpful
wow your workbook is complex
and you have a different date field for each of your measures - I'm not certain I understand the goal but your individual last dates can be found with 4 formulas like this
Now comes the problem - there are 4 different date fields that really don't know one another - it you require creating a single continuous date frame and associating each or your dates with that continuous frame - see scaffolding
don't know if you are looking at these 4 areas independently or combined - if they are individual you can use the above formulas - if you want to look at a combined result the solution is much more complex
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.