Rank and transpose in table or matrix

[Anonymous]

Hi!

I need some help to solve this problem. I have a list with the following columns: company name, year and profit. The list looks like this:

Then I would like to rank the top 3, and the bottom 3 (each year) like this(for the top 3):

..and like this for the bottom 3 (where the company ranked as 1 is the worst performing company):

Thanks in advance for any help solving this challenge!

[v-yuta-msft · Accepted solution]

@Anonymous ,

Create two calculate columns using DAX below:

Rank_Best = RANKX(FILTER('Table', 'Table'[Year] = EARLIER('Table'[Year])), 'Table'[Profit], , DESC, Dense)
Rank_Worst = RANKX(FILTER('Table', 'Table'[Year] = EARLIER('Table'[Year])), 'Table'[Profit], , ASC, Dense)

Then create two matrix visuals as below:

 

Community Support Team _ Jimmy Tao

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

[Anonymous]

@v-yuta-msft 

Thank you very much for the solution!

PS! I see now that my question was a bit too simplified regarding my actual case, but I'll send the challenge in a new post since this one is solved.

Thanks once again!!