You may want to apply LOD expressions
to capture 100% Contracts renewal --
using the 'no gap' logic, so if there is
not a single day left in gaps between
the very first Start Date and the latest End Date
for each [Customer ID] & [Contracts] combo.
Please find the attached as an example.
Hope it could help a bit.
renewals_v10.2_YF.twbx 86.1 KB
Thank you so very much!! You made that seem too easy
Cynthia, you're welcome.