need help with rankx formule

Anonymous — Wed, 14 Jun 2023 08:52:36 GMT

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

Re: need help with rankx formule

v-yueyunzh-msft — Fri, 16 Jun 2023 02:45:11 GMT

Hi, Anonymous

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

topic Re: need help with rankx formule in DAX Commands and Tips

need help with rankx formule

Re: need help with rankx formule