Tag

Power Query M Value Functions

Browsing

Power Query M Embedded.Value Function is categorized under Value Functions. This function is used to access the value by name in the embedded mashup.

Embedded.Value Function

Purpose of Power Query M Embedded.Value Function

This function is used to access the value.

Return value

This function returns an embedded.

Syntax

=Embedded.Value(value,path)

Arguments

Arguments DescriptionRemarks
value as anyMandatory
Path  as textMandatory

Power Query M Value.NativeQuery Function is categorized under Value Functions. This function is used to evaluate the provided query(s) against the target(s) by using specified parameters(s).

Value.NativeQuery Function

Purpose of Power Query M Value.NativeQuery Function

This function is used to evaluate the query.

Return value

This function returns a query.

Syntax

=Value.NativeQuery(target,query,parameters,options)

Arguments

Arguments DescriptionRemarks
target as anyMandatory
query  as textMandatory
parameters  as anyOptional
options  as nullable recordOptional

Usage Notes

  • The Output of this function is defined the target(s).

Power Query M Value.Divide Function is categorized under Value Functions. This function is used to divide value1(s)&value2(s).

Value.Divide Function

Purpose of Power Query M Value.Divide Function

This function is used to divide the provided value.

Return value

This function returns a divided value.

Syntax

=Value.Divide(value1,value2,precision)

Arguments

Arguments DescriptionRemarks
value1 as anyMandatory
value2  as anyMandatory
precision  as nullable numberOptional

Usage Notes

Power Query M Value.Multiply Function is categorized under Value Functions. This function is used to Multiply value1(s)&value2(s).

Value.Multiply Function

Purpose of Power Query M Value.Multiply Function

This function is used to Multiply the provided value.

Return value

This function returns a multiplied value.

Syntax

=Value.Multiply(value1,value2,precision)

Arguments

Arguments DescriptionRemarks
value1 as anyMandatory
value2  as anyMandatory
precision  as nullable numberOptional

Usage Notes

Power Query M Value.Subtract Function is categorized under Value Functions. This function is used to subtract value1(s)&value2(s).

Value.Subtract Function

Purpose of Power Query M Value.Subtract Function

This function is used to subtract the provided value.

Return value

This function returns a difference.

Syntax

=Value.Subtract(value1,value2,precision)

Arguments

Arguments DescriptionRemarks
value1 as anyMandatory
value2  as anyMandatory
precision  as nullable numberOptional

Usage Notes

Power Query M Value.Add Function is categorized under Value Functions. This function is used to add value1(s)&value2(s).

Value.Add Function

Purpose of Power Query M Value.Add Function

This function is used to add the provided value.

Return value

This function returns a sum value.

Syntax

=Value.Add(value1,value2,precision)

Arguments

Arguments DescriptionRemarks
value1 as anyMandatory
value2  as anyMandatory
precision  as nullable numberOptional

Usage Notes

Power Query M Value.FromText Function is categorized under Value Functions. This function is used to decode a value from the provided textual representation and also interpret it as a value with an appropriate type.

Value.FromText Function

Purpose of Power Query M Value.FromText Function

This function is used to obtain a value from the given text value.

Return value

This function returns a value.

Syntax

=Value.FromText(text,culture)

Arguments

Arguments DescriptionRemarks
value as anyMandatory
culture  as nullable textOptional

Usage Notes

  • This function returns number, a logical value, a null value, a date-time value, a duration value, or a text value from the provided text value.
  • This function returns null if the given text value is empty.

Power Query M Value.Metadata Function is categorized under Value Functions. This function is used to return a record contains the input’s metadata.

Value.Metadata Function

Purpose of Power Query M Value.Metadata Function

This function is used to obtain a record contains the input’s metadata.

Return value

This function returns a record.

Syntax

=Value.Metadata(value)

Arguments

Arguments DescriptionRemarks
value as anyMandatory

Power Query M Value.ReplaceMetadata Function is categorized under Value Functions. This function is used to replace the input’s metadata information.

Value.ReplaceMetadata Function

Purpose of Power Query M Value.ReplaceMetadata Function

This function is used to replace the input’s metadata.

Return value

This function returns a replaced metadata information.

Syntax

=Value.ReplaceMetadata(value,metavalue)

Arguments

Arguments DescriptionRemarks
value as anyMandatory
metavalue  as anyMandatory

Power Query M Value.RemoveMetadata Function is categorized under Value Functions. This function is used to clear the input of metadata.

Value.RemoveMetadata Function

Purpose of Power Query M Value.RemoveMetadata Function

This function is used to clear the metadata.

Return value

This function returns removed metadata.

Syntax

=Value.RemoveMetadata(value,metavalue)

Arguments

Arguments DescriptionRemarks
value as anyMandatory
metavalue  as anyMandatory