cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Abilaash98
Frequent Visitor

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! 

 

EmailDept_IDRole_Order
user1@company.comAAA1
user2@company.comEEE1
user2@company.comBBB2
user3@company.comCCC1
user3@company.comDDD2
user3@company.comHHH3
1 ACCEPTED SOLUTION
1 REPLY 1

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors