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
user1@company.com	AAA	1
user2@company.com	EEE	1
user2@company.com	BBB	2
user3@company.com	CCC	1
user3@company.com	DDD	2
user3@company.com	HHH	3

[amitchandak · Accepted solution]

@Abilaash98 , refer these approches

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

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