Want to create Index column using dax for a table visual

Question

Hi,&nbsp;Lets say i have a dataset&nbsp;&nbsp;A&nbsp; &nbsp;B&nbsp; &nbsp;C1&nbsp; &nbsp;2&nbsp; &nbsp;34&nbsp; &nbsp;5&nbsp; &nbsp;67&nbsp; &nbsp;8&nbsp; &nbsp;9I want to create an index column by excluding C columnA&nbsp; &nbsp;B&nbsp; &nbsp;Index1&nbsp; &nbsp;2&nbsp; &nbsp;14&nbsp; &nbsp;5&nbsp; &nbsp;27&nbsp; &nbsp;8&nbsp; &nbsp;3&nbsp;I want to use Dax measure only as i am in live connection mode and cant go to edit queries.&nbsp;

pattemmanohar · Accepted Answer

Anonymous&nbsp; Please try this as a New Table..
&nbsp;
Test189Out = SELECTCOLUMNS(Test189Rnk,"A",Test189Rnk[A],
                                      "B",Test189Rnk[B],
                                      "Index",RANKX(Test189Rnk,Test189Rnk[C],Test189Rnk[C],ASC)
                          )

Forum Discussion

Want to create Index column using dax for a table visual

1 Reply

Related content

Create columns group

Create a Dynamic Column in a Table Visual

Creating a date column

Matrix Visualization - Create Custom Total Column

Create a table visual with dynamic columns