How to add new columns and then add a ranking based on another columns values.

[bdog1971]

All I need some help with adding a few columns and then have a ranked value based on another column.  

Here is the current data.  

Project Name	Model Score	Strategy Score
Project 1	112	132
Project 2	109	124
Project 3	50	50
Project 4	104	119
Project 5	67	77
Project 6	139	174
Project 7	100	120
Project 8	127	147
Project 9	86	106
Project 10	103	118

I am trying to figure out how to get the rankings for the Model Score Ranking and Strategy Score Ranking from the Model Score and Strategy Score columns.  Below is an example I typed in but I have over a thousand rows. 

Project Name	Model Score	Strategy Score	Model Score Ranking	Strategy Score Ranking
Project 1	112	132	8	8
Project 2	109	124	7	7
Project 3	50	50	1	1
Project 4	104	119	6	5
Project 5	67	77	2	2
Project 6	139	174	10	10
Project 7	100	120	4	6
Project 8	127	147	9	9
Project 9	86	106	3	3
Project 10	103	118	5	4

Thanks again for the help. 

[Anonymous · Accepted solution]

Hi  @bdog1971 ,

Here are the steps you can follow：

1. Create calculated column.

Model Score Ranking = RANKX('Table','Table'[Model Score],,ASC)

Strategy Score Ranking = RANKX('Table','Table'[Strategy Score],,ASC)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly