percentile rank for decimal column

[anesh]

Hello all

I need to find the percentile rank of a column-type decimal. Kindly let me know the DAX calculation for it.

[lbendlin]

You can start with PERCENTILEX.INC and then refine depending on your actual scenario.

[anesh]

Thanks. What should be the value of k?. I thought it would calculate automatically for the values in the column.

[lbendlin]

No, you specify which percentile you want across a range of values. The reply gives you the cutoff for that percentile.

[anesh]

I want to achieve what PERCENTRANK.INC does this in Excel. Does it do the same?

[lbendlin]

powerbi - DAX equivalent of Excel PERCENTRANK.INC per category - Stack Overflow

[anesh]

Thanks for providing this link. I am new to DAX. It is done on the category level, but I want to do it on the entire column which is decimal type.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[anesh]

Hi @lbendlin Is there any update about this sample workbook?

[lbendlin · Accepted solution]

@anesh   Sorry missed your note.  Here is my proposal as a calculated column.

[anesh]

Thanks a lot, @lbendlin . May I know how you calculated the sample_index

[lbendlin]

that's your table name

[anesh]

Thank you so much!!

[Ashish_Mathur]

Hi,

Share the download link of the Excel workbook with the Excel formula already there.  I'll try to translate that in the DAX language.

[anesh]

sample pbix.pbix

Here is the link to the dataset