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).
| Argument | Value | Description |
|---|---|---|
| PercentileMode.ExcelInc | 1 | When interpolating values for List.Percentile, use a method compatible with Excel’s PERCENTILE.INC. |
| PercentileMode.ExcelExc | 2 | When interpolating values for List.Percentile, use a method compatible with Excel’s PERCENTILE.EXC. |
| PercentileMode.SqlDisc | 3 | When interpolating values for List.Percentile, use a method compatible with SQL Server’s PERCENTILE_DISC. |
| PercentileMode.SqlCont | 4 | When 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:
2023-2026 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy