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

Question

question

SaiharshavardhanRagyari-1083 asked · May 21 at 04:50 AM

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

10 |1000 characters needed characters left characters exceeded

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

HarshNathani-6222 · Jun 05 at 07:58 AM

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

0 · ·

1.jpg (26.9 KiB)

Answer 1 · 2020-05-21T07:31:17.137Z

VaibhavChaudhari answered · May 21 at 07:31 AM

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

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

question