Forum Discussion
Trying to do some Scoring using Percentiles
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
Super User
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!!
