PERCENTILEX.INC
A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
What is PERCENTILEX.INC?
PERCENTILEX.INC is a DAX function that returns the nth percentile of a column of numeric values. It is similar to the PERCENTILE.INC function, but with one key difference: it uses an inclusive calculation method that includes the values of the endpoints of the range. This means that if you have a set of values ranging from 1 to 10, the PERCENTILEX.INC function will include both the value of 1 and 10 in its calculation, while the PERCENTILE.INC function will not.
Syntax
The syntax for the PERCENTILEX.INC function is as follows:
PERCENTILEX.INC(❰table❱, ❰expression❱, ❰percentile❱)
– `❰table❱`: the name of the table containing the column of values you want to analyze.
– `❰expression❱`: the name of the column or DAX expression that contains the values you want to analyze.
– `❰percentile❱`: the percentile value you want to calculate, expressed as a decimal between 0 and 1.
How to Use PERCENTILEX.INC in Power BI
Using the PERCENTILEX.INC function in Power BI is a straightforward process. Here are the steps you need to follow:
Step 1: Load your data into Power BI
Before you can use the PERCENTILEX.INC function, you need to load your data into Power BI. You can do this by clicking on the “Get Data” button in the Home tab of the Power BI ribbon and selecting the type of data source you want to use.
Step 2: Create a new measure
Once you have loaded your data into Power BI, you need to create a new measure to calculate the percentile value. To do this, click on the “New Measure” button in the Modeling tab of the Power BI ribbon and enter the following formula:
MyPercentileValue = PERCENTILEX.INC(❰table❱, ❰expression❱, ❰percentile❱)
Replace `❰table❱` with the name of the table containing your data, `❰expression❱` with the name of the column or DAX expression containing the values you want to analyze, and `❰percentile❱` with the percentile value you want to calculate.
Step 3: Use the measure in your visualizations
Once you have created your measure, you can use it in your visualizations to gain insights from your data. For example, you could create a bar chart that shows the percentile values of different categories of data, or a line chart that shows how the percentile value changes over time.
The PERCENTILEX.INC function is a powerful tool in Power BI that can help you analyze and interpret large sets of data. By using this function, you can calculate the nth percentile of a column of numeric values and gain insights into the distribution of your data. Whether you are a business analyst, data scientist, or anyone else who works with data, the PERCENTILEX.INC function is a valuable addition to your analytical toolkit.