How do I a gap and island analysis with a power query?

I have a dataset similar to the one below, and I am trying to do a gap and island analysis on it.

How to do a gap and island analysis with power query?

I have a dataset similar to the one below and I am trying to do a gap and island analysis on it.