Forum Discussion
Advocate IBuilding Deadlines based off Start, End Dates and Frequency
Hello,
I’m not completely sure, but this usually happens when your grouping key isn’t really unique, so PMs from different contracts get mixed together and the index just keeps growing, that’s why you see values like 42 or 90 your Contract Key looks solid at first glance, but I’d double check for hidden nulls, text vs number mismatches, or small differences like spaces or formats, even one mismatch can merge contracts silently another thing I’d try is to sanity check the Service_Dates list itself, maybe for some rows the List.Generate condition never stops correctly, so you’re generating way more dates than expected, you could temporarily add a List.Count column to confirm if I had to simplify, I’d compute the expected number of PMs first using something like duration / frequency and cap the list explicitly, instead of relying only on the <= EndDate condition, that’s usually more robust
Best regards,
Daniele
Super UserHello,
I’m not completely sure, but this usually happens when your grouping key isn’t really unique, so PMs from different contracts get mixed together and the index just keeps growing, that’s why you see values like 42 or 90 your Contract Key looks solid at first glance, but I’d double check for hidden nulls, text vs number mismatches, or small differences like spaces or formats, even one mismatch can merge contracts silently another thing I’d try is to sanity check the Service_Dates list itself, maybe for some rows the List.Generate condition never stops correctly, so you’re generating way more dates than expected, you could temporarily add a List.Count column to confirm if I had to simplify, I’d compute the expected number of PMs first using something like duration / frequency and cap the list explicitly, instead of relying only on the <= EndDate condition, that’s usually more robust
Best regards,
Daniele
Community SupportHi quincy_p ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank DanieleUgoCopp , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support Team