Saurabh Jain
-
Posts
1,726 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
Returns a sorted list using comparison criterion.
-
Returns the minimum values in a list. The number of values to return or a filtering condition may be specified.
-
Returns the minimum item in a list, or the optional default value if the list is empty.
-
Returns the median item from a list.
-
Returns the maximum values in the list. The number of values to return or a filtering condition must be specified.
-
Returns the maximum item in a list, or the optional default value if the list is empty.
-
Returns a list of lists combining items at the same position.
-
Returns a list from a list of lists and unions the items in the individual lists. The returned list contains all items in any input lists. Duplicate values are matched as part of the Union.
-
Returns a list from a list of lists and intersects common items in individual lists. Duplicate values are supported.
-
Returns the items in list 1 that do not appear in list 2. Duplicate values are supported.
-
Finds the first occurrence of any value in values and returns its position.
-
Finds the first occurrence of a value in a list and returns its position.
-
Returns true if any item in values is found in a list.
-
Returns true if all items in values are found in a list.
-
Returns true if a value is found in a list.
-
Returns true if any expression in a list in true
-
Returns true if all expressions in a list are true
-
Returns a list whose elements are projected from the input list.
-
Performs the function on each item in the list and returns the new list.
-
Splits the specified list into a list of lists using the specified page size.
-
Returns a list that reverses the items in a list.
-
Searches a list of values for the value and replaces each occurrence with the replacement value.
-
Replaces occurrences of existing values in the list with new values using the provided equationCriteria. Old and new values are provided by the replacements parameters. An optional equation criteria value can be specified to control equality comparisons. For details of replacement operations and equation criteria, go to Parameter values.
-
Removes null values from a list.
-
Removes all occurrences of the given values in the list.
