Forum Discussion

Imran_Isshack's avatar
Imran_Isshack
Frequent Visitor
3 years ago
Solved

Repost from earlier with sample data: PERCENTRANK FUNCTION - Equivalent in DAX

Hi Power Bi Friends, I inherited an MS Excel model and wanted to transition it to Power Pivot so that It becomes dynamic.  This Excel model has the PERCENTRANK FUNCTION, which I can't seem to find ...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

     

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

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

 

 

Imran_Isshack's avatar
Imran_Isshack
Frequent Visitor
3 years ago

v-yueyunzh-msft 

 

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