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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

There's no magic formule that can helps me do that ? 

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
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