Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All - hoping for some assistance here with Ranking on couple of dimensional attributes
I've a requirement to show top 10 projects that will have certain types of impact.
I've a table about projects and go live dates and impacts looking like this (dates are dd/mm/yyyy)
Since the table creation in this forum cannot be more than 10 rows, for argument's sake lets work on top 5
Project Name | Go live date | Impact | Ranking | |||
Project1 | 11/08/2021 | H | 1 | |||
Project2 | 23/08/2021 | H | 1 | |||
Project3 | 25/09/2021 | H | 1 | |||
Project4 | 29/09/2021 | H | 1 | |||
Project5 | 02/10/2021 | M | 2 | |||
Project6 | 15/10/2021 | M | 2 | |||
Project7 | 31/10/2021 | M | 2 |
So from above the requirement is just to show the top 5 entries. Upto Project5. I dont want the remaining entries.
Hope that is sufficient info to help me out.
Thank you
Solved! Go to Solution.
@Anonymous Not sure but maybe TRIMMEAN? TRIMMEAN - Microsoft Power BI Community
Where is the ranking coming from? Is it in the table?
@Anonymous Not sure but maybe TRIMMEAN? TRIMMEAN - Microsoft Power BI Community
Where is the ranking coming from? Is it in the table?
Wow!! Are you suggesting to get only top N rows of the list, I need to write such a long complicated DAX?
Isn't it an over kill?
..........Were my thoughts when I saw your response. But then I thought of trying it out.
And it worked.
Thanks a lot @Greg_Deckler That was really helpful.
Thanks
@Anonymous Glad someone could use that formula because it was a total PITA to write it!!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |