Value.Type Function in Power Query

The Value.Type function in Power Query returns the type of the given value.

Syntax

Value.Type(value as any) as type

It returns the type of the given value (e.g., type text, type number, type date, etc.).

Example:

Power Query M

let
    Source = Value.Type("123")
in
    Source          

The output of the above code is text.

Example: Check Type After Value.FromText.

Power Query M

let
    Source = Value.Type(Value.FromText("true"))
in
    Source          

The output of the above code is logical.