A type value is a value used to categorize other values into specific data types. The M Language offers an extensive range of type values to help you classify and manage different types of data effectively.
Available Type Values
Power Query offers the following type values:
| Facet | Type | Description |
|---|---|---|
| Any.Type | type any | The type that represents all values. |
| Binary.Type | type binary | The type that represents all binary values. |
| Byte.Type | The type that represents all bytes. | |
| Character.Type | The type that represents all characters. | |
| Currency.Type | The type that represents currency value. | |
| Date.Type | type date | The type that represents all date values. |
| DateTime.Type | type datetime | The type that represents all date and time values without an associated timezone. |
| DateTimeZone.Type | type datetimezone | The type that represents all date and time values relative to a timezone. |
| Decimal.Type | type number | The type that represents fixed-point decimal number. |
| Double.Type | The type that represents double precision floating point number. | |
| Duration.Type | type duration | The type that represents all duration values |
| Function.Type | type function | The type that represents all functions. |
| Guid.Type | The type that represents a Guid value. | |
| Int16.Type | The type that represents signed 16 bit integer. | |
| Int32.Type | The type that represents signed 32 bit integer. | |
| Int64.Type | The type that represents signed 64 bit integer. | |
| Int8.Type | The type that represents signed 8 bit integer. | |
| List.Type | type list | The type that represents all lists. |
| Logical.Type | type logical | The type that represents all logical values. |
| None.Type | type none | The type that represents no values. |
| Null.Type | type null | The type that represents null. |
| Number.Type | The type that represents all numbers. | |
| Password.Type | The type that represents a text password. | |
| Percentage.Type | The type that represents percentage value. | |
| Record.Type | type record | The type that represents all records. |
| Single.Type | The type that represents single precision floating point number. | |
| Table.Type | type table | The type that represents all tables. |
| Text.Type | type text | The type that represents all text values. |
| Time.Type | type time | The type that represents all time values. |
| Type.Type | type type | The type that represents all types. |
| Uri.Type | The type that represents a text URI. |
