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
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
- 20 views
Value.RemoveMetadata

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

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

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

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

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

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

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

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

By Saurabh Jain, in Functions, January 2
Returns the sum of the two values.
- Read more...
- 0 comments
- 23 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