Add a Group Number

[amulder]

Hi,

I am trying to create a new column in Power BI that will allow me to group my data by a subset of the entire table. Here is what I am trying to accomplish.

Event Number	Unit	Status	Group Number
1234	Truck	DP	1
1234	Car	DP	2
1234	Truck	AM	1
1234	Car	AM	2
1234	Truck	DP	3
5522	Truck	DP	4

<tbody>
</tbody>

The Group Number column is what I need to create and is based on the following:
1. Group by Event Number and Unit
2. The Group Number is autogenterated
3. The Group Number starts when the status is DP end then restarts at the next DP within the same Event Number and Unit group

How can I do this?

Thanks in advance!