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 solutions provided by community members were helpful in addressing the issue.
If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar