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 …