Forum Discussion
Solved
Identify service episodes and group dates
Hi All, I would like to thank all of you who have helped me in the past and i am looking for additional help. I am trying to identify episodes of service and identify the earliest start date ...
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,
Does this link work?
https://1drv.ms/x/c/9eb0597c98b072c8/ETotvxO5OGdOnbOX3yiidqoBWUuEZzv-vRJmAg33xSBxVQ?e=xh1Fii
Kind regards
Hetal
That link works ok.
But it seems to me that all of the examples you have provided in that link are continuous or overlapping and, since they all include a null end date, would all have null as the transformed end date.
Is that really the case? Or am I missing something?