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 …