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

Want to create Index column using dax for a table visual

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.



 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Want to create Index column using dax for a table visual

@ShubhamK  Please try this as a New Table..

 

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

image.png



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

Proud to be a Datanaut !





1 REPLY 1
Super User
Super User

Re: Want to create Index column using dax for a table visual

@ShubhamK  Please try this as a New Table..

 

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

image.png



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

Proud to be a Datanaut !