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 list that replaces count values in a list with a replaceWith list starting at an index.
-
Returns a list that repeats the contents of an input list count times.
-
Returns a list with the specified number of elements removed from the list starting at the last element. The number of elements removed depends on the optional countOrCondition parameter.
-
Removes items from list1 that are present in list2, and returns a new list.
-
Returns a list with the specified number of elements removed from the list starting at the first element. The number of elements removed depends on the optional countOrCondition parameter.
-
Returns a list that removes count items starting at offset. The default count is 1.
-
Merges a list of lists into single list.
-
Accumulates a result from the list. Starting from the initial value seed this function applies the accumulator function and returns the final result.
-
Skips the first item of the list. Given an empty list, it returns an empty list. This function takes an optional parameter countOrCondition to support skipping multiple values.
-
Returns a single item from a list.
-
Returns the single item of the list or throws an Expression.Error if the list has more than one item.
-
Selects the items that match a condition.
-
Returns a count items starting at an offset.
-
Returns a list of positions for an input list.
-
Returns true if any item in a list meets a condition.
-
Returns true if all items in a list meet a condition.
-
Returns the last set of items in a list by specifying how many items to return or a qualifying condition.
-
Returns the last set of items in the list by specifying how many items to return or a qualifying condition provided by countOrCondition.
-
Returns whether a list is distinct.
-
Inserts items from values at the given index in the input list.
-
Returns the first set of items in the list by specifying how many items to return or a qualifying condition provided by countOrCondition.
-
Returns the first value of the list or the specified default if empty. Returns the first item in the list, or the optional default value, if the list is empty. If the list is empty and a default value is not specified, the function returns.
-
Searches a list of values, including record fields, for a text value.
-
Filters a list down by removing duplicates. An optional equation criteria value can be specified to control equality comparison. The first value from each equality group is chosen.
-
Buffers the list in memory. The result of this call is a stable list, which means it will have a determinimic count, and order of items.
