Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Xavier
Regular Visitor

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 1
harshnathani
Community Champion
Community Champion

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)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors