Value functions
Value functions functions for Power Query M language.
Functions
| Function | Description |
|---|---|
| DirectQueryCapabilities.From | This function is designed to be used only within the organization. |
| Embedded.Value | Retrieves a specific value from an embedded mashup using its corresponding name. |
| Excel.ShapeTable | This function is designed to be used only within the organization. |
| Graph.Nodes | This function is designed to be used only within the organization. |
| Progress.DataSourceProgress | This function is designed to be used only within the organization. |
| SqlExpression.SchemaFrom | This function is designed to be used only within the organization. |
| SqlExpression.ToExpression | This function is designed for internal use only and is responsible for converting the given SQL query into M code using the identifiers available in the environment. |
| Value.Add | This function calculates the addition of value1 and value2. Users have the option to specify a precision parameter, with the default being Precision.Double. |
| Value.Alternates | This function demonstrates different ways to execute queries within a query plan expression obtained using Value.Expression(Value.Optimize(...)). It should not be used for other purposes. |
| Value.As | This function will provide the value if it is suitable for the specified type. It works similarly to the "as" operator in M, but with the added capability of accepting identifier type references like ... |
| Value.Compare | Returns a value of 1, 0, or -1 depending on whether value1 is greater than, equal to, or less than value2. It is possible to include a comparer function if desired. |
| Value.Divide | This function calculates the quotient of value1 divided by value2. Users have the option to specify a precision parameter, with the default precision being set to Precision.Double. |
| Value.Equals | This function will return true if the value of value1 is equal to the value of value2, and false if they are not equal. |
| Value.Expression | It retrieves an abstract syntax tree (AST) that illustrates the expression of the value. |
| Value.Firewall | This function is designed to be used only within the organization. |
| Value.FromText | The function Value.FromText converts a value from its textual form to a specific data type. It can interpret the input text as a number, logical value, null value, datetime value, duration value, or t... |
| Value.Is | This function checks if a value is suitable for a specific type. It performs a similar action to the "is" operator in M language, but with the added ability to recognize identifier type references lik... |
| Value.Lineage | This function is designed to be used only within the organization. |
| Value.Metadata | Returns a set of information about the input provided. |
| Value.Multiply | This function calculates the result of multiplying value1 by value2. Users can also specify a precision parameter, which defaults to Precision.Double if not specified. |
| Value.NativeQuery | Assesses the query against a specified target using the parameters and options provided. The result of the query is determined by the target, which sets the context for the query operation. The query ... |
| Value.NullableEquals | If either value1 or value2 is null, the function will return null. Otherwise, it will behave in the same way as the Value.Equals function. |
| Value.Optimize | When utilized in Value.Expression, if the value denotes a query that is optimizable, this function specifies that the optimized expression should be delivered. If the value does not represent an optim... |
| Value.RemoveMetadata | This function eliminates the metadata associated with the value and outputs the initial value. |
| Value.ReplaceMetadata | Updates the metadata associated with a specific value by replacing it with the new metadata record provided. The original value is then returned with the updated metadata appended to it. |
| Value.ReplaceType | Changes the data type of the value to the specified type. |
| Value.Subtract | This function calculates the numerical difference between two values, value1 and value2. Users have the option to specify the level of precision they desire. If no precision is specified, the default ... |
| Value.Traits | This function is designed to be used only within the organization. |
| Value.Type | This function will provide information on the data type of the specified value. |
| Value.VersionIdentity | This function will provide the version number of the value, or return null if the value does not have a version. |
| Value.Versions | Generates a navigation table that displays the different versions of the value that are available. |
| Value.ViewError | This function is designed to be used only within the organization. |
| Value.ViewFunction | This function is designed to be used only within the organization. |
| Variable.Value | This function is designed to be used only within the organization. |