Value Functions
SqlExpression.ToExpression
Syntax SqlExpression.ToExpression(sql as text, environment as record) as text Description SqlExpression.ToExpression Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …
Value.As
Syntax Value.As(value as any, type as type) as any Description Value.As Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …
Value.Add
Syntax Value.Add(value1 as any, value2 as any, optional precision as nullable number) as any Description …
Value.NativeQuery
Syntax Value.NativeQuery(target as any, query as text, optional parameters as any, optional options as nullable …
Precision.Double
Syntax null Description An optional parameter for the built-in arithmetic operators to specify double precision. …
Value.ReplaceMetadata
Syntax Value.ReplaceMetadata(value as any, metaValue as any) as any Description Replaces the input’s metadata information. …
Value.Equals
Syntax Value.Equals(value1 as any, value2 as any, optional precision as nullable number) as logical Description …
Value.Is
Syntax Value.Is(value as any, type as type) as logical Description Value.Is Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …
SqlExpression.SchemaFrom
Syntax SqlExpression.SchemaFrom(schema as any) as any Description SqlExpression.SchemaFrom Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions …
Value.Subtract
Syntax Value.Subtract(value1 as any, value2 as any, optional precision as nullable number) as any Description …
Precision.Decimal
Syntax null Description An optional parameter for the built-in arithmetic operators to specify decimal precision. …
Variable.Value
Syntax Variable.Value(identifier as text) as any Description Variable.Value Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions …
DirectQueryCapabilities.From
Syntax DirectQueryCapabilities.From(value as any) as table Description DirectQueryCapabilities.From Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions …
Value.Divide
Syntax Value.Divide(value1 as any, value2 as any, optional precision as nullable number) as any Description …
Value.ReplaceType
Syntax Value.ReplaceType(value as any, type as type) as any Description Value.ReplaceType Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …
Value.Compare
Syntax Value.Compare(value1 as any, value2 as any, optional precision as nullable number) as number Description …
Value.RemoveMetadata
Syntax Value.RemoveMetadata(value as any, optional metaValue as any) as any Description Strips the input of …
Value.Type
Syntax Value.Type(value as any) as type Description Returns the type of the given value. Reference …
Value.Multiply
Syntax Value.Multiply(value1 as any, value2 as any, optional precision as nullable number) as any Description …
Value.Firewall
Syntax Value.Firewall(key as text) as any Description Value.Firewall Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions …
Value.NullableEquals
Syntax Value.NullableEquals(value1 as any, value2 as any, optional precision as nullable number) as nullable logical …
Value.Metadata
Syntax Value.Metadata(value as any) as any Description Returns a record containing the input’s metadata. Reference …
Embedded.Value
Syntax Embedded.Value(value as any, path as text) as any Description Accesses a value by name …