Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
14 | |
14 | |
9 |