Recurring Serial Number using Power Query Editor

[Abilaash98]

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! 

Email	Dept_ID	Role_Order
[email protected]	AAA	1
[email protected]	EEE	1
[email protected]	BBB	2
[email protected]	CCC	1
[email protected]	DDD	2
[email protected]	HHH	3

[amitchandak · Accepted solution]

@Abilaash98 , refer these approches

https://www.youtube.com/watch?v=7ypdbuCeBtk

https://www.youtube.com/watch?v=7CqXdSEN2k4