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

     

5 Replies

  • 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

     

  • 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".