Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
These functions evaluate and perform operations on values.
| Name | Description |
|---|---|
| Value.Alternates | Expresses alternate query plans. |
| 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.Expression | Returns an abstract syntax tree (AST) that represents the value's expression. |
| Value.VersionIdentity | Returns the version identity of a value. |
| Value.Versions | Returns a navigation table containing the available versions of a value. |
| Value.NativeQuery | Evaluates a query against a target. |
| Value.NullableEquals | Returns a logical value or null based on two values. |
| Value.Optimize | If value represents a query that can be optimized, returns the optimized query. Otherwise returns value. |
| Value.Type | Returns the type of the given value. |
Arithmetic operations
| Name | 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. |
Parameter types
| Name | 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.ReplaceType | Replaces the value's type. |
| Implementation | 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. |
| 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 | This function is intended for internal use only. |
| Value.Firewall | This function is intended for internal use only. |
| 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. |
Metadata
| Name | Description |
|---|---|
| Value.Metadata | Returns a record containing the input’s metadata. |
| Value.RemoveMetadata | Removes the metadata on the value and returns the original value. |
| Value.ReplaceMetadata | Replaces the metadata on a value with the new metadata record provided and returns the original value with the new metadata attached. |
Lineage
| Name | Description |
|---|---|
| Graph.Nodes | 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. |