List Functions Overview

Learn about List Functions in Power Query M Language, crucial when working with lists in your data manipulation tasks. This page provides a comprehensive list and descriptions of List Functions available in the M Language.

Table of contents

• Generator Functions
• Information Functions
• Selection Functions
• Statistical Functions
• Transformation Functions

Generator Functions

Function	Description
List.Accumulate	Accumulates a summary value from the items in the list.
List.DateTimeZones	Generates a list of datetimezone values given an initial value, count, and incremental duration value.
List.DateTimes	Generates a list of datetime values given an initial value, count, and incremental duration value.
List.Dates	Generates a list of date values given an initial value, count, and incremental duration value.
List.Durations	Generates a list of duration values given an initial value, count, and incremental duration value.
List.Generate	Generates a list of values.
List.Numbers	Returns a list of numbers given an initial value, count, and optional increment value.
List.Random	Returns a list of random numbers.
List.Repeat	Returns a list that is count repetitions of the original list.
List.Times	Generates a list of time values given an initial value, count, and incremental duration value.

Information Functions

Function	Description
List.AllTrue	Returns true if all expressions are true.
List.AnyTrue	Returns true if any expression is true.
List.Contains	Indicates whether the list contains the value.
List.ContainsAll	Indicates where a list includes all the values in another list.
List.ContainsAny	Indicates where a list includes any of the values in another list.
List.IsDistinct	Indicates whether there are duplicates in the list.
List.IsEmpty	Returns true if the list is empty.
List.MatchesAll	Returns true if the condition function is satisfied by all values in the list.
List.MatchesAny	Returns true if the condition function is satisfied by any value.
List.PositionOf	Returns the offset(s) of a value in a list.
List.PositionOfAny	Returns the first offset of a value in a list.
List.Positions	Returns a list of offsets for the input.

Selection Functions

Function	Description
List.Alternate	Returns a list comprised of all the odd numbered offset elements in a list.
List.Buffer	Buffers a list.
List.FindText	Returns a list of values (including record fields) that contain the specified text.
List.First	Returns the first value of the list or the specified default if empty.
List.FirstN	Returns the first set of items in the list by specifying how many items to return or a qualifying condition.
List.Last	Returns the last value of the list or the specified default if empty.
List.LastN	Returns the last value in the list
List.Max	Returns the maximum value or the default value for an empty list.
List.MaxN	Returns the maximum value(s) in the list
List.Min	Returns the minimum value or the default value for an empty list.
List.MinN	Returns the minimum value(s) in the list
List.Range	Returns a subset of the list beginning at an offset.
List.Select	Returns a list of values that match the condition.
List.Single	Returns the one list item for a list of length one, otherwise throws an exception.
List.SingleOrDefault	Returns the one list item for a list of length one and the default value for an empty list.

Statistical Functions

Function	Description
List.Average	Returns the average of the values
List.Count	Returns the number of items in the list.
List.Covariance	Returns the covariance between the two lists of numbers.
List.Median	Returns the median value in the list.
List.Mode	Returns the most frequent value in the list.
List.Modes	Returns a list of the most frequent values in the list.
List.NonNullCount	Returns the number of non-null items in the list.
List.Percentile	Returns one or more sample percentiles corresponding to the given probabilities.
List.Product	Returns the product of the numbers in the list.
List.StandardDeviation	Returns a sample based estimate of the standard deviation.
List.Sum	Returns the sum of the items in the list.

Transformation Functions

Function	Description
List.Combine	Returns a single list by combining multiple lists.
List.ConformToPageReader	This function is intended for internal use only.
List.Difference	Returns the difference of the two given lists.
List.Distinct	Returns a list of values with duplicates removed.
List.InsertRange	Inserts values into a list at the given index.
List.Intersect	Returns the intersection of the list values found in the input.
List.RemoveFirstN	Returns a list that skips the specified number of elements at the beginning of the list.
List.RemoveItems	Removes items from list1 that are present in list.
List.RemoveLastN	Returns a list that removes the specified number of elements from the end of the list.
List.RemoveMatchingItems	Removes all occurrences of the input values.
List.RemoveNulls	Removes all “null” values from the specified list.
List.RemoveRange	Removes count number of values starting at the specified position.
List.ReplaceMatchingItems	Applies each replacement of { old, new }.
List.ReplaceRange	Replaces count number of values starting at position with the replacement values.
List.ReplaceValue	Searches a list for the specified value and replaces it.
List.Reverse	Reverses the order of values in the list.
List.Skip	Returns a list that skips the specified number of elements at the beginning of the list.
List.Sort	Sorts a list of data according to the criteria specified.
List.Split	Splits the specified list into a list of lists using the specified page size.
List.Transform	Returns a new list of values computed from this list.
List.TransformMany	Returns a list whose elements are transformed from the input list using specified functions.
List.Union	Returns the union of the list values found in the input.
List.Zip	Returns a list of lists by combining items at the same position in multiple lists.

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/list-functions