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

Distinct Row Numbers based on Column value

Afternoon, 

 

I'm trying to ascertain whether it is possible to add a column that displays a sequential number for each row that has a duplicate reference. For example I have a column of references where it is possible to have multiple rows. I wish to append a number to each reference based on row count number:

 

 

ReferenceSeq RowAppended
1011101-1
1012101-2
1013101-3
1021102-1
1022102-2
1031103-1
1041104-1
1051105-1
1052105-2
1053105-3

 

Is this possible?

 

Thanks in advance

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@robcrockfordYou can do this in the Query Editor

1) Group By

2) Add Custom Column {1..[Count]}

3) Expand to New Rows

4) Remove Column

5) Merge Column (Rename resulting column if you'd like)

6) Close & Apply

 

Sequential Numbers.gif

 

Hope this helps! Smiley Happy

 

View solution in original post

1 REPLY 1
Sean
Community Champion
Community Champion

@robcrockfordYou can do this in the Query Editor

1) Group By

2) Add Custom Column {1..[Count]}

3) Expand to New Rows

4) Remove Column

5) Merge Column (Rename resulting column if you'd like)

6) Close & Apply

 

Sequential Numbers.gif

 

Hope this helps! Smiley Happy

 

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!

Top Solution Authors