Add index column at table view

[kusanagi]

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 add a new table using summarize, so there is no Power Query for this table.

Is there any dax function having same effect?

[ryan_mayu]

@kusanagi 

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))

[kusanagi]

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

[Ahmedx]

pls try this

[ryan_mayu · Accepted solution]

@kusanagi 

pls try this

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