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

[datasetleo]

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!

[v-piga-msft · Accepted solution]

Hi @datasetleo ,

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