Int16.From is a Power Query M function that converts a given value to a 16-bit integer, applying rounding if necessary. The function returns either a 16-bit integer or null if the given value is null.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Int16.From(
value as any,
optional culture as nullable text,
optional roundingMode as nullable number,
) as nullable number| Argument | Attribute | Description |
|---|---|---|
| value | ||
| culture | optional | The culture argument enables the specification of a Culture code (e.g., “nl-NL” or “en-US”) to align transformations with local formatting conventions. If this argument is omitted, functions default to Culture.Current, which reflects the system’s regional settings. |
| roundingMode | optional | The RoundingMode.Type argument controls the rounding method applied. When omitted, the function uses RoundingMode.ToEven, which rounds to the nearest even number in tie situations. Other options include: – RoundingMode.Up rounds up in such cases. – RoundingMode.Down rounds down. – RoundingMode.TowardZero rounds toward zero. – RoundingMode.AwayFromZero rounds away from zero. |