Index column in dax

[Anonymous]

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 !

[Anonymous]

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

[v-easonf-msft · Accepted solution]

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]

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

[Anonymous]

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

Thank you so much everbody 🙂

[v-easonf-msft]

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