The Power query M library

One on One Extensive Advanced Excel Training

Power Query M function dictionary

Show all categories
Value.ReplaceMetadata

By Saurabh Jain, in Functions, January 2, 2023
Replaces the metadata on a value with the new metadata record provided and returns the original value with the new metadata attached.
- Read more...
- 0 comments
- 142 views
Value.RemoveMetadata

By Saurabh Jain, in Functions, January 2, 2023
Removes the metadata on the value and returns the original value.
- Read more...
- 0 comments
- 143 views
Value.Metadata

By Saurabh Jain, in Functions, January 2, 2023
Returns a record containing the input’s metadata.
- Read more...
- 0 comments
- 133 views
Value.ReplaceType

By Saurabh Jain, in Functions, January 2, 2023
Replaces the value's type.
- Read more...
- 0 comments
- 110 views
Value.Is

By Saurabh Jain, in Functions, January 2, 2023
Determines whether a value is compatible with the specified type.
- Read more...
- 0 comments
- 152 views
Value.As

By Saurabh Jain, in Functions, January 2, 2023
Returns the value if it is compatible with the specified type.
- Read more...
- 0 comments
- 130 views
Value.Subtract

By Saurabh Jain, in Functions, January 2, 2023
Returns the difference of the two values.
- Read more...
- 0 comments
- 73 views
Value.Multiply

By Saurabh Jain, in Functions, January 2, 2023
Returns the product of the two values.
- Read more...
- 0 comments
- 73 views
Value.Divide

By Saurabh Jain, in Functions, January 2, 2023
Returns the result of dividing the first value by the second.
- Read more...
- 0 comments
- 149 views
Value.Add

By Saurabh Jain, in Functions, January 2, 2023
Returns the sum of the two values.
- Read more...
- 0 comments
- 81 views

Sign In

Power Query M function dictionary

Value.ReplaceMetadata

Value.RemoveMetadata

Value.Metadata

Value.ReplaceType

Value.Is

Value.As

Value.Subtract

Value.Multiply

Value.Divide

Value.Add

Activity

Browse