There are six DAX functions in this function group that will help you calculate percentile values for a given set of data. They are PERCENTILE.EXC, PERCENTILE.INC, PERCENTILEX.EXC, PERCENTILEX.INC, MEDIAN, and MEDIANX.
A percentile is a statistical measure that gives the value where a certain percentage of values in a dataset fall below it. For example, the 30th percentile will be the value in a dataset where 30% of the values fall below it, and the remaining 70% are above it.
Before we start to look at these functions, let's use the following expression to create a new table, which will contain the numbers 1 through to 20:
Numbers = GENERATESERIES ( 1, 20 )
Now, we can use this table as our dataset to help us understand how these functions work. We'll start by looking at the first of these functions.