Forum Discussion
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...
maybe you can try to use rankx to create the index column
Table 2 =
VAR tbl=SUMMARIZE('Table','Table'[id],"amount",sum('Table'[value]))
return ADDCOLUMNS(tbl,"Index",rankx(all('Table'[id]),'Table'[id],,ASC))
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.
| Item | amount | rankx | what I want |
a | 2 | 1 | 1 |
| b | 2 | 1 | 2 |
| c | 4 | 3 | 3 |
| d | 5 | 4 | 4 |
| e | 5 | 4 | 5 |
