DAX Fridays! #133: PERCENTILE.EXC and PERCENTILE.INC

In today's video I will explain how to calculate quartiles in power bi and why they are useful.
Happy summer! #curbal #powerbi #dax #daxfridays

SUBSCRIBE to learn more about Power and Excel BI!

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#daxfridays #curbal #dax #powerbi #mvp

[theunknown]

@4:24 Q1 is not equal to the average (mean) of 1+2+3+4+5, Q1 is the median of (1, 2, 3, 4, 5), which is 3 in both cases. I think that the mean will always be equal to the median for any set of numbers incremented by 1. So for (11, 10) the mean and median are both 10.5.

If your set of numbers was (2, 2, 2, 4, 5, 5, 7, 8, 9, 10, 11), then Q1 would be 2, but your way the mean would be (2+2+2+4+5)/5=3.

Why would Q2 be the median of the entire set and Q1 be the mean of the the first half? It does not follow intuitively (statistics is frequently counter intuitive, but in this case it is intuitive).

[snehakedambadi]

Mam you are a very good teacher, specially i like that smiling face of yours, gives a positive mindset for learning. And yes i am implementing these function now.

[pimvicini]

Thank you for this video! However, can someone help me understand the following? In the video (e.g. 1.29 and 4.00) she uses median and average as two interchangeable terms (in my perception), saying that the q2 is the average of the data. and the q1 is the average of the data to the  left of q2.. I was under the impression that this is about the 'place' in the data, and 'average' is not correct for this. Can someone help me by clarifying? Thanks!

[knowtechwithaman]

nice video about the percentiles, I have a query here that can we make a percentile meter or filter for a column in the dataset, which includes all percentiles from 1 to 100.

[jimayas]

Hey Ruth!
Thank you so much for the lesson!
It's a joy watching your videos!

[andrecavasotero]

Another statistic lesson using Power BI, explained in a way that you do not need to be a statistician to understand. Few people explore this area, congratulations!

[maximilianomartinez]

Hola Ruth! Tienes algun ejemplo donde uses Percentilex.exc? Gracias! :)

[claudiacaceres]

Thank you so much for your videos. I have a question, is there a way of calculating percentile for a time field?

[gnavarrolema]

Thank you for clearing up my doubt about how these DAX functions work

[joseagundis]

Me gusta que nos pongas a pensar diferentes escenarios, saludos Ruth.

[Gledii]

Hi, i have a measure that calculates the SUMX of seveal columns. Now i just want to create a new measure to calculate the % of the previous one. somehow i cant load the previous measure, it only let me use the Sum function with columns...any tip? thanks

[MacPaulos]

A very special thank you :). Looking to apply lessons learned to my dataset to get a better idea of storytelling. Thanks again, Ruth!!!

[JoyceSantos-bnuq]

Thank you so much!!! <3 <3 <3 you're amazing!!!

[ayobamiologun]

Good job always. Thanks for the knowledge sharing.

[jonathanjedrczak]

Thanks for another great video Ruth! I really appreciate your videos and I'm always trying to share them around the office. As a possible future video idea, I would really appreciate if one day you could do a video on "regular expression style problems" in Power BI. For example, I haven't found an elegant solution to a problem like "filter for cases where column y has the format '99XX99'". Thanks again for all the content!!

[akrishnaprasanth]

Great Videos! Btw, I enjoy the accent so much :)

[didierterrien]

Thanks a lot Ruth!
How to put 2 thumbs up ??? 😀

[rodrsturge]

Ok so I know what the values are for Q1, Q2, Q3, Q4. What I want to do is rank my managers based on a score, and put them in a quartile.... and then someone will come along and remove the heads of everyone in the bottom quartile.

[Exodiq]

5% doesnt work, but try with 9.5 % and it should work. Even though it still doesnt make sence :D