DAX query (index in powerBI)

[Anonymous]

Hi all,

I have a calculated column to which I would like to allot index from the highest to the lowest.

For eg:

This is my table.

I would want EDU 1000 = index 1

                               250 = 2

                                112 = 3 and so on..

Can I please know how to achieve that in PowerBI?

Any help is appreciated!

Thank you!

Megha

[amitchandak · Accepted solution]

@Anonymous , Rank in DAX

new column =

Rankx(Table, [EDU],,desc,dense)

[Anonymous]

Thank you! @amitchandak