Forum Discussion
Repost from earlier with sample data: PERCENTRANK FUNCTION - Equivalent in DAX
Hi , Imran_Isshack
For your need , you want to convert the "PERCENTRANK FUNCTION" to dax . Right?
As searched , there is no PERCENTRANK function in DAX, you can manually calculate it from the results of RANKX and COUNTROWS.
For more information, you can refer to :
powerbi - DAX equivalent of Excel PERCENTRANK.INC per category - Stack Overflow
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
Community SupportHi , Imran_Isshack
For your need , you want to convert the "PERCENTRANK FUNCTION" to dax . Right?
As searched , there is no PERCENTRANK function in DAX, you can manually calculate it from the results of RANKX and COUNTROWS.
For more information, you can refer to :
powerbi - DAX equivalent of Excel PERCENTRANK.INC per category - Stack Overflow
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
Thanks very much for your response.
Yes, I would like the DAX equivalent of Excel's PERCENTRANK.
You're right, I have been searching google for a few days now and can't seem to find the equivalent.
I saw this post before "powerbi - DAX equivalent of Excel PERCENTRANK.INC per category - Stack Overflow" but it seems so long and complicated and scared me away 🙂 . I do hope I would be able to use this successfully.
Imran
