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

Question

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

Saiharshavardhan Ragyari 1

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

Harsh Nathani 1 Reputation point

2020-06-05T07:58:01.637+00:00

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

1 answer

Your answer

Harsh Nathani 1 Reputation point

2020-06-05T07:58:01.637+00:00

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

Answer 1

Vaibhav Chaudhari 38,921 Volunteer Moderator

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 via

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

1 answer

Your answer