Archive

Value.Type

Syntax Value.Type(value as any) as type Description Returns the type of the given value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Value.Type

Value.Multiply

Syntax Value.Multiply(value1 as any, value2 as any, optional precision as nullable number) as any Description Returns the product of multiplying 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.Multiply

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

Value.NullableEquals

Syntax Value.NullableEquals(value1 as any, value2 as any, optional precision as nullable number) as nullable logical Description Returns null if either argument value1, value2 is null, otherwise equivalent to Value.Equals. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Value.NullableEquals

Value.Metadata

Syntax Value.Metadata(value as any) as any Description Returns a record containing the input’s metadata. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Value.Metadata

Embedded.Value

Syntax Embedded.Value(value as any, path as text) as any Description Accesses a value by name in an embedded mashup. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Embedded.Value

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 Functions / DirectQueryCapabilities.From

Uri.Parts

Syntax Uri.Parts(absoluteUri as text) as record Description Returns the parts of the input absoluteUri as a record, containing values such as Scheme, Host, Port, Path, Query, Fragment, UserName and Password. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Uri Functions / Uri.Parts

Uri.BuildQueryString

Syntax Uri.BuildQueryString(query as record) as text Description Assemble the record query into a URI query string, escaping characters as necessary. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Uri Functions / Uri.BuildQueryString

Uri.Combine

Syntax Uri.Combine(baseUri as text, relativeUri as text) as text Description Returns an absolute URI that is the combination of the input baseUri and relativeUri. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Uri Functions / Uri.Combine