Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
patri0t82
Post Patron
Post Patron

Creating a calculated column that Ranks based on multiple other sorted columns

Hello, any help is very much appreciated. I would like to create a calculated column. My table is called CapitalManagementSource.
I have three columns I'd like to take into account. PRF_Number, Cost and Year
 
I would like to create a column that ranks each PRF_Number. First in the ranking would be the minimum [Year] with the largest SUM of [Cost], second would be the minimum [Year] with the second largest [Cost], until all way through to the latest [Year] with the lowest [Cost].
 
In other words, I would like to create a new column ranking the PRF_Number column by two layers
1) Year - Min > Max
2) Cost - Max > Min
1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.