Value.Type is a Power Query M function that retrieves the type of a given input value. The function returns the type of the input value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Value.Type( value as any ) as type


Returns the type of the given value.


To test the type of a value, you use the Value.Type function.

Value.Type( "abc" )            // Returns type text
Value.Type( 2024 )             // Returns type number
Value.Type( #time(9,30,0) )    // Returns type time
Value.Type( { 1, "a", true } ) // Returns type list

Besides returning common type values like number or text, remember that a (data) type also has a type. The following expression returns type type for the ‘type text’.

Value.Type( type text ) // Returns type type

Other functions related to Value.Type are:

BI Gorilla Youtube Channel

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.