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 of employees. For example, the value of the salary above which the top 10% of employees are paid.
Thank you very much
1 Reply
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 NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
