Forum Discussion
Trying to do some Scoring using Percentiles
Struggling with something that seemed to be simple before DAX... beginner here trying to convert a
column of percentages (fill rates) for our supplier base into percentiles for scoring purposes.
Supplier FillRate% Percentile
A 16.5% ?
B 99.5% ?
C 85.8% ?
D 68.5% ?
I've spent a day now researching the DAX Percentile functions and can't seem to get that Percentile column
populated. Any help would be so appreciated!
Thanks
Sounds like you're wanting the equivalent of Excel's PERCENTRANK function.
Have a look at this thread for some sample DAX you could adapt:
http://community.powerbi.com/t5/Desktop/PERCENTRANK-Inclusive/m-p/81208
In my (OwenAuger) post there is some code that should replicate Excel's function including handling ties, which was quite long-winded to be honest.
v-sihou-msft's post has a simpler formula that works fine without ties.
Cheers,
Owen
2 Replies
Sounds like you're wanting the equivalent of Excel's PERCENTRANK function.
Have a look at this thread for some sample DAX you could adapt:
http://community.powerbi.com/t5/Desktop/PERCENTRANK-Inclusive/m-p/81208
In my (OwenAuger) post there is some code that should replicate Excel's function including handling ties, which was quite long-winded to be honest.
v-sihou-msft's post has a simpler formula that works fine without ties.
Cheers,
Owen
Exactly what I was looking for, thanks a million!!
