Type conversion
Published: July 18, 2015
Updated: July 18, 2015
The Power Query M formula language has formulas to convert between types. The following is a summary of conversion formulas in M.
| Type conversion | Description |
|---|---|
| Number.FromText(text as text) as number | Returns a number value from a text value. |
| Number.ToText(number as number) as text | Returns a text value from a number value. |
| Number.From(value as any) as number | Returns a number value from a value. |
| Int32.From(value as any) as number | Returns a 32-bit integer number value from the given value. |
| Int64.From(value as any) as number | Returns a 64-bit integer number value from the given value. |
| Single.From(value as any) as number | Returns a Single number value from the given value. |
| Double.From(value as any) as number | Returns a Double number value from the given value. |
| Decimal.From(value as any) as number | Returns a Decimal number value from the given value. |
| Currency.From(value as any) as number | Returns a Currency number value from the given value. |
| Type conversion | Description |
|---|---|
| Text.From(value as any) as text | Returns the text representation of a number, date, time, datetime, datetimezone, logical, duration or binary value. |
| Type conversion | Description |
|---|---|
| Logical.FromText(text as text) as logical | Returns a logical value of true or false from a text value. |
| Logical.ToText(logical as logical) as text | Returns a text value from a logical value. |
| Logical.From(value as any) as logical | Returns a logical value from a value. |
| Type conversion | Description |
|---|---|
| .FromText(text as text) as date, time, datetime, or datetimezone | Returns a date, time, datetime, or datetimezone value from a set of date formats and culture value. |
| .ToText(date, time, dateTime, or dateTimeZone as date, time, datetime, or datetimezone) as text | Returns a text value from a date, time, datetime, or datetimezone value. |
| .From(value as any) | Returns a date, time, datetime, or datetimezone value from a value. |
| .ToRecord(date, time, dateTime, or dateTimeZone as date, time, datetime, or datetimezone) | Returns a record containing parts of a date, time, datetime, or datetimezone value. |
Show: