Forum Discussion
Percentile, Quantile, Top N ?
Hello everybody, This is my first post. I have a basic Employees Excel Sheet with two columns (Matricule, Annual Salary). I would like to calculate the salary above which there is a percentage ...
Hi Xavier ,
You can use the formula
TOP 10 = PERCENTILE.INC(ALL('Table'),.90)
This will give you the threshold or 90percentile value or people who are in top 10 percentile salary.
You can also refer the post
https://community.powerbi.com/t5/Desktop/Calculating-the-percentile-for-a-set-of-data/td-p/250581
https://community.powerbi.com/t5/Desktop/Dynamic-calculation-of-percentiles/td-p/458233
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)