Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello i need some help 2 creat 2 rank colums based on points
i need 2 rankx colums based on punten etappe and based on punten totaal so the people in colum naam wil get a rank based on the points
these are points people earn by predicting the tour de france
Hi, @Krijgerss21
According to your description, do you want to create two ranking columns? Or what about creating a ranking column based on two columns?
According to your description and your screenshots, I don't fully understand your needs. For creating sort columns, I can give you two functions.
If you need to sort by a certain column, you can try to use the rankx function, for this , you can refer to :
Using the RANKX function in Power BI – SQLServerCentral
If you need to sort by multiple columns, you can try to use the RANK function, for this , you can refer to :
RANK function (DAX) - DAX | Microsoft Learn
If the above can't help you, you can describe your sorting logic in detail (such as which columns or columns need to be grouped), you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |