Archive

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 Query M Functions / Value Functions / Value.Is

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 Functions / SqlExpression.SchemaFrom

Syntax Value.Subtract(value1 as any, value2 as any, optional precision as nullable number) as any Description Returns the difference of value1 and value2. An optional precision parameter may be specified, by default Precision.Double is used. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions /… Read More »Value.Subtract

Syntax null Description An optional parameter for the built-in arithmetic operators to specify decimal precision. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Precision.Decimal

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 / Value Functions / Variable.Value

Syntax Value.NativeQuery(target as any, query as text, optional parameters as any, optional options as nullable record) as any Description Evaluates query against target using the parameters specified in parameters and the options specified in options. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions… Read More »Value.NativeQuery

Syntax Value.Divide(value1 as any, value2 as any, optional precision as nullable number) as any Description Returns the result of dividing value1 by value2. An optional precision parameter may be specified, by default Precision.Double is used. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions… Read More »Value.Divide

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 Query M Functions / Value Functions / Value.ReplaceType

Syntax Value.Compare(value1 as any, value2 as any, optional precision as nullable number) as number Description Returns -1, 0, or 1 based on whether the first value is less than, equal to, or greater than the second one. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »Value.Compare

Syntax Value.RemoveMetadata(value as any, optional metaValue as any) as any Description Strips the input of metadata. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Value.RemoveMetadata