List Functions

List.Numbers

Syntax List.Numbers(start as number, count as number, optional increment as nullable number) as list Description …

List.RemoveLastN

Syntax List.RemoveLastN(list as list, optional countOrCondition as any) as list Description Returns a list that …

List.TransformMany

Syntax List.TransformMany(list as list, collectionTransform as function, resultTransform as function) as list Description Returns a …

List.DateTimes

Syntax List.DateTimes(start as datetime, count as number, step as duration) as list Description Returns a …

List.Single

Syntax List.Single(list as list) as any Description If there is only one item in the …

List.Modes

Syntax List.Modes(list as list, optional equationCriteria as any) as list Description Returns the item that …

List.Buffer

Syntax List.Buffer(list as list) as list Description Buffers the list list in memory. The result …

List.MaxN

Syntax List.MaxN(list as list, countOrCondition as any, optional comparisonCriteria as any, optional includeNulls as nullable …

List.IsEmpty

Syntax List.IsEmpty(list as list) as logical Description Returns true if the list, list, contains no …

List.MinN

Syntax List.MinN(list as list, countOrCondition as any, optional comparisonCriteria as any, optional includeNulls as nullable …

List.Union

Syntax List.Union(lists as list, optional equationCriteria as any) as list Description Takes a list of …

List.PositionOfAny

Syntax List.PositionOfAny(list as list, values as list, optional occurrence as nullable number, optional equationCriteria as …

List.Count

Syntax List.Count(list as list) as number Description Returns the number of items in the list …

List.LastN

Syntax List.LastN(list as list, optional countOrCondition as any) as any Description Returns the last item …

List.Split

Syntax List.Split(list as list, pageSize as number) as list Description Splits list into a list …

List.Average

Syntax List.Average(list as list, optional precision as nullable number) as any Description Returns the average …

List.Contains

Syntax List.Contains(list as list, value as any, optional equationCriteria as any) as logical Description Indicates …

List.ReplaceRange

Syntax List.ReplaceRange(list as list, index as number, count as number, replaceWith as list) as list …

List.Times

Syntax List.Times(start as time, count as number, step as duration) as list Description Returns a …

List.MatchesAny

Syntax List.MatchesAny(list as list, condition as function) as logical Description Returns true if the condition …

List.ReplaceMatchingItems

Syntax List.ReplaceMatchingItems(list as list, replacements as list, optional equationCriteria as any) as list Description Performs …

List.ContainsAny

Syntax List.ContainsAny(list as list, values as list, optional equationCriteria as any) as logical Description Indicates …

List.RemoveMatchingItems

Syntax List.RemoveMatchingItems(list1 as list, list2 as list, optional equationCriteria as any) as list Description Removes …

List.Alternate

Syntax List.Alternate(list as list, count as number, optional repeatInterval as nullable number, optional offset as …

List.Distinct

Syntax List.Distinct(list as list, optional equationCriteria as any) as list Description Returns a list that …

List.Dates

Syntax List.Dates(start as date, count as number, step as duration) as list Description Returns a …

List.RemoveItems

Syntax List.RemoveItems(list1 as list, list2 as list) as list Description Removes all occurrences of the …

List.Reverse

Syntax List.Reverse(list as list) as list Description Returns a list with the values in the …

List.ReplaceValue

Syntax List.ReplaceValue(list as list, oldValue as any, newValue as any, replacer as function) as list …

List.FindText

Syntax List.FindText(list as list, text as text) as list Description Returns a list of the …

List.StandardDeviation

Syntax List.StandardDeviation(numbersList as list) as nullable number Description Returns a sample based estimate of the …

List.MatchesAll

Syntax List.MatchesAll(list as list, condition as function) as logical Description Returns true if the condition …

List.Random

Syntax List.Random(count as number, optional seed as nullable number) as list Description Returns a list …

List.Covariance

Syntax List.Covariance(numberList1 as list, numberList2 as list) as nullable number Description Returns the covariance between …

List.Max

Syntax List.Max(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as …

List.FirstN

Syntax List.FirstN(list as list, countOrCondition as any) as any Description Find the intial values in …

List.Generate

Syntax List.Generate(initial as function, condition as function, next as function, optional selector as nullable function) …

List.Durations

Syntax List.Durations(start as duration, count as number, step as duration) as list Description Returns a …

List.Skip

Syntax List.Skip(list as list, optional countOrCondition as any) as list Description Returns a list that …

List.Mode

Syntax List.Mode(list as list, optional equationCriteria as any) as any Description Returns the item that …

List.NonNullCount

Syntax List.NonNullCount(list as list) as number Description Returns the number of non-null items in the …

List.Last

Syntax List.Last(list as list, optional defaultValue as any) as any Description Returns the last item …

List.RemoveFirstN

Syntax List.RemoveFirstN(list as list, optional countOrCondition as any) as list Description Returns a list that …

List.Range

Syntax List.Range(list as list, offset as number, optional count as nullable number) as list Description …

List.AllTrue

Syntax List.AllTrue(list as list) as logical Description Returns true if all expressions in the list …

List.Median

Syntax List.Median(list as list, optional comparisonCriteria as any) as any Description Returns the median item …

List.Positions

Syntax List.Positions(list as list) as list Description Returns a list of offsets for the input …

List.Intersect

Syntax List.Intersect(lists as list, optional equationCriteria as any) as list Description Returns the intersection of …

List.Sum

Syntax List.Sum(list as list, optional precision as nullable number) as any Description Returns the sum …

List.RemoveNulls

Syntax List.RemoveNulls(list as list) as list Description Removes all occurrences of “null” values in the …

List.InsertRange

Syntax List.InsertRange(list as list, index as number, values as list) as list Description Returns a …

List.Zip

Syntax List.Zip(lists as list) as list Description Takes a list of lists, lists, and returns …

List.Transform

Syntax List.Transform(list as list, transform as function) as list Description Returns a new list of …

List.Difference

Syntax List.Difference(list1 as list, list2 as list, optional equationCriteria as any) as list Description Returns …

List.Sort

Syntax List.Sort(list as list, optional comparisonCriteria as any) as list Description Sorts a list of …

List.Product

Syntax List.Product(numbersList as list, optional precision as nullable number) as nullable number Description Returns the …

List.IsDistinct

Syntax List.IsDistinct(list as list, optional equationCriteria as any) as logical Description Returns a logical value …

List.SingleOrDefault

Syntax List.SingleOrDefault(list as list, optional default as any) as any Description If there is only …

List.Accumulate

Syntax List.Accumulate(list as list, seed as any, accumulator as function) as any Description Accumulates a …

List.AnyTrue

Syntax List.AnyTrue(list as list) as logical Description Returns true if any expression in the list …

List.ContainsAll

Syntax List.ContainsAll(list as list, values as list, optional equationCriteria as any) as logical Description Indicates …

List.First

Syntax List.First(list as list, optional defaultValue as any) as any Description Returns the first item …

List.PositionOf

Syntax List.PositionOf(list as list, value as any, optional occurrence as nullable number, optional equationCriteria as …

List.Min

Syntax List.Min(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as …

List.Combine

Syntax List.Combine(lists as list) as list Description Takes a list of lists, lists, and merges …

List.Repeat

Syntax List.Repeat(list as list, count as number) as list Description Returns a list that is …

List.DateTimeZones

Syntax List.DateTimeZones(start as datetimezone, count as number, step as duration) as list Description Returns a …

List.Select

Syntax List.Select(list as list, selection as function) as list Description Returns a list of values …

List.RemoveRange

Syntax List.RemoveRange(list as list, index as number, optional count as nullable number) as list Description …