| Power Query M

Delve into Value Functions in Power Query M Language, useful when performing operations on values. This page provides a comprehensive list and descriptions of Value Functions available in the M Language.

Evaluation and Conversion

Function	Description
Value.Expression	Returns an abstract syntax tree (AST) that represents the value’s expression.
Value.FromText	Creates a strongly typed value from a textual representation.
Value.NativeQuery	Evaluates a query against a target.
Value.Optimize	Signals Value.Expression to return the optimized expression for a value.

Type and Metadata

Function	Description
Value.As	Returns the value if it is compatible with the specified type.
Value.Is	Determines whether a value is compatible with the specified type.
Value.Metadata	Returns a record containing the input’s metadata.
Value.RemoveMetadata	Strips the input of metadata.
Value.ReplaceMetadata	Replaces the input’s metadata information.
Value.ReplaceType	Replaces the value’s type.

Value Comparison

Function	Description
Value.Compare	Returns -1, 0, or 1 based on whether the first value is less than, equal to, or greater than the second.
Value.Equals	Returns whether two values are equal.
Value.NullableEquals	Returns whether two values are equal.

Value Operations

Function	Description
Value.Add	Returns the sum of the two values.
Value.Divide	Returns the result of dividing the first value by the second.
Value.Multiply	Returns the product of the two values.
Value.Subtract	Returns the difference of the two values.

Other Functions

Function	Description
Action.WithErrorContext	This function is intended for internal use only.
DirectQueryCapabilities.From	This function is intended for internal use only.
Embedded.Value	Accesses a value by name in an embedded mashup.
Excel.ShapeTable	This function is intended for internal use only.
Graph.Nodes	This function is intended for internal use only.
Module.Versions	Returns a record of module versions for the current module and its dependencies.
Progress.DataSourceProgress	This function is intended for internal use only.
SqlExpression.SchemaFrom	This function is intended for internal use only.
SqlExpression.ToExpression	Converts the provided SQL query to M code
Value.Alternates	Expresses alternate query plans.
Value.Firewall	This function is intended for internal use only.
Value.Lineage	This function is intended for internal use only.
Value.Traits	This function is intended for internal use only.
Value.Type	Returns the type of the given value.
Value.VersionIdentity	Returns the version identity of the value, or null if it doesn’t have a version.
Value.Versions	Returns a navigation table containing the available versions of value.
Value.ViewError	This function is intended for internal use only.
Value.ViewFunction	This function is intended for internal use only.
Variable.Value	This function is intended for internal use only.

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/value-functions