Forum Discussion

kusanagi's avatar
kusanagi
Frequent Visitor
2 years ago
Solved

Add index column at table view

There is a function in Power Query  of adding Index Column. Index Column numbered the rows starting from 1 or 0 without repeating numbers. I need the same function but in table view.   I ad...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    kusanagi 

    pls try this

    Table 2 = ADDCOLUMNS('Table',"Index",RANKX(all('Table'[Item]),'Table'[Item],,ASC))

kusanagi's avatar
kusanagi
Frequent Visitor
2 years ago

Hi Ryan, 

Thank for your reply.

 

I have tried rankx too.

However, I have plenty item with same amount in my case.

I don't want same number coming up.

Here's the example.

Itemamountrankxwhat I want

a

211
b212
c433
d544
e545

 

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

kusanagi 

pls try this

Table 2 = ADDCOLUMNS('Table',"Index",RANKX(all('Table'[Item]),'Table'[Item],,ASC))