Value.Type Function in Power Query

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

Syntax

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.