Syntax List.Alternate(list as list, count as number, optional repeatInterval as nullable number, optional offset as nullable number) as list Description Returns a list comprised of all the odd numbered offset elements in a list. Alternates between taking and skipping values from the list list depending… Read More »List.Alternate
Syntax List.RemoveMatchingItems(list1 as list, list2 as list, optional equationCriteria as any) as list Description Removes all occurrences of the given values in list2 from the list list1. If the values in list2 don’t exist in list1, the original list is returned. An optional equation criteria… Read More »List.RemoveMatchingItems
Syntax List.Union(lists as list, optional equationCriteria as any) as list Description Takes a list of lists lists, unions the items in the individual lists and returns them in the output list. As a result, the returned list contains all items in any input lists. This… Read More »List.Union
Syntax List.ContainsAny(list as list, values as list, optional equationCriteria as any) as logical Description Indicates whether the list list includes any of the values in another list, values. Returns true if value is found in the list, false otherwise. An optional equation criteria value, equationCriteria,… Read More »List.ContainsAny
Syntax List.ReplaceMatchingItems(list as list, replacements as list, optional equationCriteria as any) as list Description Performs the given replacements to the list list. A replacement operation replacements consists of a list of two values, the old value and new value, provided in a list. An optional… Read More »List.ReplaceMatchingItems
Syntax List.MinN(list as list, countOrCondition as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as list Description Returns the minimum value(s) in the list, list. The parameter, countOrCondition, specifies the number of values to return or a filtering condition. The optional parameter, comparisonCriteria,… Read More »List.MinN
Syntax List.PositionOfAny(list as list, values as list, optional occurrence as nullable number, optional equationCriteria as any) as any Description Returns the offset in list list of the first occurrence of a value in a list values. Returns -1 if no occurrence is found. An optional… Read More »List.PositionOfAny
Syntax List.Count(list as list) as number Description Returns the number of items in the list list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Count
Syntax List.LastN(list as list, optional countOrCondition as any) as any Description Returns the last item of the list list. If the list is empty, an exception is thrown. This function takes an optional parameter, countOrCondition, to support gathering multiple items or filtering items. countOrCondition can… Read More »List.LastN
Syntax List.Split(list as list, pageSize as number) as list Description Splits list into a list of lists where the first element of the output list is a list containing the first pageSize elements from the source list, the next element of the output list is… Read More »List.Split