Identify service episodes and group dates

hi v-karpurapud 

sorry for delay in replying. I have had a look at the example PBI you have sent and not sure if it is displaying as expected.

I have created a table with all the fields and comparing the element dates with the episode dates.

For ID 7290, not an issue as the episode start and end is what i expect. However many of the others don't appear correct.

ID 24050 for example has 5 lines

Line 1 - Element start 01/11/2021 end date null

Line 2 - Element start 01/11/2021 end date 27/04/2025

Line 3 - Element start 08/05/2023 end date 27/04/2025

Line 4 - Element Start 29/04/2024 end 27/04/2025

Line 5 - Element Start 28/04/2025 end date null

For Lines 1-4 the episode start date is 01/11/2021 and end date is 27/04/2025 and Line 5 episode start is 28/04/2025 with end date null.

This is not what i expected. i would want to see the episode start as 01/11/2021 and end date as null as service user has a service open since 01/11/2021.

Another example, id 37493 who has 3 lines:

Line 1 - Start 01/04/2024 and end 27/04/2025

Line 2 - Start 01/04/2024 and end 29/05/2025

Line 3 - Start 28/04/2025 and end date null

The episode date shows start as 01/04/2024 and end date as 29/05/2025. The expected result is start 01/04/2024 and end date as null because there is still an open service and all dates are continuous.

I have found this issue where it works for some cases but not for others and it is frustrating.

I appeciate the help you have provided but unfortunately still not giving the desired results.

kind regards

Hetal