question

SaiharshavardhanRagyari-1083 avatar image
SaiharshavardhanRagyari-1083 asked ·

Create a rank column by using values from other column in Power BI

I need to achieve rank column as below. Kindly help. Thanks in advance.

 Column1 Rank
 93           1
 93           1
 93           1
 92           2
 91           3
 87           4
 56           5
 34           6
 34           6
 34           6
 26           7
 15           8
 12           9
 9                  10


not-supported
1 comment
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Create a supported Calculated Column


SUM1 = 'Table'[Column1]

and then use the rank function

Create another Calculated Column

RANK =

var a = RANKX('Table','Table'[SUM1])

RETURN
a


9182-1.jpg


0 Votes 0 · ·
1.jpg (26.9 KiB)

1 Answer

VaibhavChaudhari avatar image
VaibhavChaudhari answered ·

Currently Power BI related questions are not supported on this forum.

It's better to post the question in below dedicated forum:

PBI_Comm_Forums




If the response helped, do "Accept Answer" and upvote it - Vaibhav

Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.