Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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