Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Index column in dax

Hello Evrybody, i wanna create an index column in dax (not in power query) based on a number. Here's the result wanted. Any help, please !  
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, Anonymous 

    Maybe you can try adding small random numbers for sorting.

    Calculated column:

    Column = 'Table'[Number]+RAND()/1000
    Rank1 = RANKX(ALL('Table'),'Table'[Column],,ASC,Dense)

     

    Best Regards,
    Community Support Team _ Eason

     

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

Usually we can use "Rankx" to create an index column if your column does not contain duplicate values.

Currently, It is almost impossible to create an index column based on a column containing duplicate values in DAX.

Best Regards,
Community Support Team _ Eason