PercentileMode.Type

Updated on

PercentileMode.Type specifies the percentile mode type.

Enumeration Options

Enumerations simplify the process of selecting options within a function. To specify the PercentileMode.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).

ArgumentValueDescription
PercentileMode.ExcelInc1When interpolating values for List.Percentile, use a method compatible with Excel’s PERCENTILE.INC.
PercentileMode.ExcelExc2When interpolating values for List.Percentile, use a method compatible with Excel’s PERCENTILE.EXC.
PercentileMode.SqlDisc3When interpolating values for List.Percentile, use a method compatible with SQL Server’s PERCENTILE_DISC.
PercentileMode.SqlCont4When interpolating values for List.Percentile, use a method compatible with SQL Server’s PERCENTILE_CONT.

Applies to

Here’s a list of functions that work with PercentileMode.Type:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/percentilemode-type