cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Itay Regular Visitor
Regular Visitor

Index Column By Category

Hey, I Searched for a solution all over the forum, there are some similar but i did not figure out how to do it correctly.

 

What I'm trying to do is to add an index column, which tells me the row number for the CustIt. I've already sorted the data by date (Descending), and now i'm trying to add the column.

 

I've marked in red what i meant.

 

Thanks for your help!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Index Column By Category

  • Groupby CustID using All Rows in the Operation
  • Add a custom column with:
Table.AddIndexColumn([Whatever You Named the Column in the Prev Step], "Index", 1, 1)
  • Remove all the other columns except the one just created
  • Expand out
  • Remove any misc columns you dont need and set data types

View solution in original post

3 REPLIES 3
Stachu Super Contributor
Super Contributor

Re: Index Column By Category

this article gives an example how to do it:
https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User
Super User

Re: Index Column By Category

  • Groupby CustID using All Rows in the Operation
  • Add a custom column with:
Table.AddIndexColumn([Whatever You Named the Column in the Prev Step], "Index", 1, 1)
  • Remove all the other columns except the one just created
  • Expand out
  • Remove any misc columns you dont need and set data types

View solution in original post

Itay Regular Visitor
Regular Visitor

Re: Index Column By Category

@Nick_M Thank you!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 166 members 1,767 guests
Please welcome our newest community members: