Grouping

Hi Greg_Deckler ImkeF 

Please see link to download CSV example

https://1drv.ms/u/s!AmQ0-fnxPpEChh-3s3DR9i_WcWqS?e=Z1jauJ

I Apologise as I realised my explanation has not been very good. Please see below hope it explains my dillemma better.

I have a table in Power BI which contains a column called “Cycle State”. There are basically 7 states of a cycle which are sequentially as follows:

1. Loading
2. Fully Loaded
3. Stopped Loaded
4. Traveling Loaded
5. Dumping
6. Traveling Empty
7. Stopped Empty

The data I am looking at is second by second data log files coming of the trucks. So for every second it records what state of the cycle it is in. Each complete cycle (From Loading to Stopped Empty) varies in the number of rows as it depends on how long it took to complete each cycle state.  For example a complete cycle could look like:

Or

Is there a way I can basically group each one of these cycles and name them with a number that increases sequentially, for example the first example would be cycle 1 and the second example could be cycle 2? (Basically the new cycle will start once Loading has recommenced after Stopped Empty has occurred)

Thanks for your help