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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I can't do that because my column doesn't only contains numbers. It contains text fileds too such as "A1000".

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        I converted that column to text and then i used the function concatenate and it's working.

        Thank you so much everbody 🙂