Value Functions
Functions for inspecting and comparing values of any type.
- Action.WithErrorContextWraps an action with additional error context text that is included in any error raised during the action's execution.
- DirectQueryCapabilities.FromReturns a table describing the DirectQuery capabilities of the specified value. Intended for internal use only.
- Embedded.ValueAccesses a value within an embedded resource by path. Intended for internal use only.
- Geography.FromWellKnownTextTranslates text representing a geographic value in Well-Known Text (WKT) format into a structured record.
- Geography.ToWellKnownTextTranslates a structured geographic point value into its Well-Known Text (WKT) representation.
- GeographyPoint.FromCreates a record representing a geographic point from its constituent parts such as longitude, latitude, and optional elevation.
- Geometry.FromWellKnownTextTranslates text representing a geometric value in Well-Known Text (WKT) format into a structured record.
- Geometry.ToWellKnownTextTranslates a structured geometric point value into its Well-Known Text (WKT) representation.
- GeometryPoint.FromCreates a record representing a geometric point from its constituent parts such as X coordinate, Y coordinate, and optional Z coordinate.
- Graph.NodesReturns the nodes from a graph value represented as a record. Intended for internal use only.
- Module.VersionsReturns a record of module versions for the current module and its dependencies.
- Progress.DataSourceProgressReports data source loading progress to the evaluation environment. Intended for internal use only.
- Value.AddReturns the sum of two values, with support for numbers, durations, and date/time types.
- Value.AlternatesExpresses alternate query plans within a query plan expression. Not intended for general use.
- Value.AsAsserts that a value is compatible with a specified type, raising an error if not.
- Value.CompareCompares two values and returns -1, 0, or 1 indicating their relative order.
- Value.DivideReturns the result of dividing one value by another, with support for numbers and durations.
- Value.EqualsReturns true if two values are equal, with an optional custom comparer function.
- Value.ExpressionReturns an abstract syntax tree (AST) representation of the expression that produces the given value.
- Value.FirewallReturns a firewall-partitioned value for the given key. Intended for internal use only.
- Value.FromTextConverts a text value to a typed value based on its content.
- Value.IsChecks whether a value is compatible with a specified type.
- Value.LineageReturns the lineage information associated with a value, tracking its data source origins. Intended for internal use only.
- Value.MetadataReturns the metadata record associated with a value.
- Value.MultiplyReturns the product of multiplying two values, with support for numbers and durations.
- Value.NativeQueryExecutes a native query (e.g., SQL) against a data source, bypassing M query folding.
- Value.NullableEqualsCompares two values for equality, returning null if either value is null (three-valued logic).
- Value.OptimizeReturns an optimized form of the given value, hinting to the engine that query optimization should be applied.
- Value.RemoveMetadataReturns a copy of a value with all metadata removed, or with specified metadata fields removed.
- Value.ReplaceMetadataReturns a copy of a value with its metadata replaced by the given metadata record.
- Value.ReplaceTypeReplaces the type metadata of a value without converting the value itself.
- Value.SubtractReturns the difference of two values, with support for numbers, durations, and date/time types.
- Value.TraitsReturns a table describing the traits (capabilities and behaviors) of the given value. Intended for internal use only.
- Value.TypeReturns the type of a value.
- Value.VersionIdentityReturns the version identity of a value, or null if the value has no version.
- Value.VersionsReturns a navigation table containing the available versions of the given value.
- Value.ViewErrorCreates a modified error record suitable for use in a view handler. Intended for internal use only.
- Value.ViewFunctionCreates a view-aware wrapper around a function for use in the view infrastructure. Intended for internal use only.
- Variable.ValueReturns the value of a variable identified by name from the current evaluation environment.
- Variable.ValueOrDefaultReturns the value of a variable identified by name, or an optional default value if the variable is not defined.