Recurring Serial Number using Power Query Editor

Hello,

I want to create a new column (Role_Order) in the existing table connected via import mode in Power BI.

The new column should have serial number, but it should start with 1 for every  unique email and fill the series down. Is there any way to do it in power query editor.

Any suggestion/ idea would be great help!