Forum Discussion
Solved
Count based on same end and start date
Hi, When the next Start_Date is the same as the previous End_Date (or before) for the same "Name", I need this to count as 1. For example: Glasgow had an end date of 01/02/2025 for r111; th...
Hi RichOB,
Thank you for reaching out to the Microsoft Fabric Forum Community. And thnaks to FBergamaschi for promt and helpful response.
I’ve tried to reproduce the scenario using the M code below. Please review and adjust it according to your data source. If the issue still persists, feel free to share more details, and we’ll be happy to assist further.
Thanks & Regards,
Prasanna Kumar
Hi RichOB,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
Best regards,
Prasanna Kumar