How to match score to rank?

[Anonymous]

Hello everyone,

Sorry it might be an easy question, but I haven't found a quick solution for that.

If I have a list of students

+--------+----+
| Tom | 62 |
+--------+----+
| Chad | 97 |
+--------+----+
| Sherry | 53 |
+--------+----+
| Jim | 72 |
+--------+----+
| Kate | 89 |
+--------+----+
| Smith | 66 |
+--------+----+

And I have a ranking table

+-----+-----+------+
| Min | Max | Rank |
+-----+-----+------+
| 0 | 60 | F |
+-----+-----+------+
| 60 | 80 | C |
+-----+-----+------+
| 80 | 90 | B |
+-----+-----+------+
| 90 | 100 | A |
+-----+-----+------+

Is there an easy way in DAX to match the score to rank?

Thanks in advance!

[AllisonKennedy · Accepted solution]

@Anonymous  This is a good question. It is very possible, let me know if you think the solution is easy or not. 

Here is my blog post explaining how to do what you're asking, which is basically an approximate lookup in DAX.

https://excelwithallison.blogspot.com/2020/06/dax-approximate-lookup.html

Just replace the bonus amounts in my example with the scores in your data. Let me know if you have any trouble implementing.

[Anonymous]

Thank you. Glad you have an almost exact same use case