Skip to content
Advertisement

Group Date ranges with separate groups if other date in between

I have a Table like this:

I want to select an Start Date and an End date and group them by Specification. So my Output should look like this:

I tried it with:

but this doesnt give my desired result. Does anyone have an Idea?

Advertisement

Answer

You can try the below – it’s a gap & island problem

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement