Number.FromText is a Power Query M function that creates a number value from a given text representation, with support for common text formats and an optional culture parameter. The function returns the created number value.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Number.FromText(
text as nullable text,
optional culture as nullable text,
) as nullable number| Argument | Attribute | Description |
|---|---|---|
| text | ||
| 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. |