Forum Discussion
Identify service episodes and group dates
Hi hpatel24779
Sorry for getting back to you later than expected. I have attached the revised .PBIX file and snapshots for reference. Please review it and let us know if you need any additional help.
Regards,
Microsoft Fabric Community Support Team.
Hi hpatel24779
Thank you for reaching out to the Microsoft Fabric Community Forum.
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file and screenshot for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!
Regards,
Microsoft Fabric Community Support.
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
Hi hpatel24779
Sorry for getting back to you later than expected. I have attached the revised .PBIX file and snapshots for reference. Please review it and let us know if you need any additional help.
Regards,
Microsoft Fabric Community Support Team.