Type conversion

  • Article

The Power Query M formula language has formulas to convert between types. The following is a summary of conversion formulas in M.

Number

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.

Text

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.

Logical

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.

Date, Time, DateTime, and DateTimeZone

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.