Want to create Index column using dax for a table visual

[Anonymous]

Hi,

Lets say i have a dataset 

A   B   C

1   2   3
4   5   6
7   8   9

I want to create an index column by excluding C column

A   B   Index

1   2   1
4   5   2
7   8   3

 I want to use Dax measure only as i am in live connection mode and cant go to edit queries.

[PattemManohar · Accepted solution]

@Anonymous  Please try this as a New Table..

Test189Out = SELECTCOLUMNS(Test189Rnk,"A",Test189Rnk[A],
                                      "B",Test189Rnk[B],
                                      "Index",RANKX(Test189Rnk,Test189Rnk[C],Test189Rnk[C],ASC)
                          )