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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## PERCENTILE.INC & PERCENTILE.EXC does not yield the desired value

 Name Marks A 10 A 20 A 30 A 40 A 50 A 60

PERCENTILE.INC(Table[Marks],0.25) =22.5
PERCENTILE.EXC(Table[Marks],0.25) =17.5

I would like to determine Q1 from dataset. Q1 should be 20.
Why do the results produced by DAX above not equivalent to 20?

4 REPLIES 4
Super User

Hi,

Even in MS Excel, the answer is 22.5.  So that answer seems correct.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Frequent Visitor

Excel and Power BI share same function. Needless to say, both yield the same output.

If we were going to determine Q1 using conventional method, we will be sorting the group of data in ascending order (in this case, 10,20,30,40,50,60).

Q1 is deemed the half of half of dataset. Therefore, the first half is "10,20,30.". Subsequently, we further dive into second half between 10 and 30, yielding 20 as Q1 value.

Community Support

Hi @Nigel99,

I'd like to suggest you take a look at the following link about PERCENTILE functions if it help you to understand these functions and usages:

Regards,

XIaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Frequent Visitor

Unfortunately, the video does not seem to explain the function in details.

Excel and Power BI share same function. Needless to say, both yield the same output.

If we were going to determine Q1 using conventional method, we will be sorting the group of data in ascending order (in this case, 10,20,30,40,50,60).

Q1 is deemed the half of half of dataset. Therefore, the first half is "10,20,30.". Subsequently, we further dive into second half between 10 and 30, yielding 20 as Q1 value. This baffles me as both outputs are contradicting to each other.

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors