Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Excel Power Query - M code for PERCENTRANK.INC; any thoughts?

Hi, All!   I am trying to add a column with what in excel would be =PERCENTRANK.INC([column_name],$B3) essentially, "column_name" are all rows within the column.      Any thoughts?   Thanks!
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    I have not found the similar fucntions with PERCENTRANK.INC in Power Query. 

    However, here is a similar dax function PERCENTILE.INC(<column>, <k>) in power bi.

    In addition, you could have a reference of this similar thread which calculate PERCENTRANK.INC the with DAX in Power BI.

    If you still need help, please share your data sample and your desired output so that we could help further on it.

    If you really want to use power query, please refer to this similar thread which should be helpful or ImkeF  may have other ideas.

    Best  Regards,

    Cherry

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

I have not found the similar fucntions with PERCENTRANK.INC in Power Query. 

However, here is a similar dax function PERCENTILE.INC(<column>, <k>) in power bi.

In addition, you could have a reference of this similar thread which calculate PERCENTRANK.INC the with DAX in Power BI.

If you still need help, please share your data sample and your desired output so that we could help further on it.

If you really want to use power query, please refer to this similar thread which should be helpful or ImkeF  may have other ideas.

Best  Regards,

Cherry