Syntax List.Min(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any Description Returns the minimum item in the list list, or the optional default value default if the list is empty. An optional comparisonCriteria value, comparisonCriteria, may… Read More »List.Min
Syntax List.PositionOf(list as list, value as any, optional occurrence as nullable number, optional equationCriteria as any) as any Description Returns the offset at which the value value appears in the list list. Returns -1 if the value doesn’t appear. An optional occurrence parameter occurrence can… Read More »List.PositionOf
Syntax List.First(list as list, optional defaultValue as any) as any Description Returns the first item in the list list, or the optional default value, defaultValue, if the list is empty. If the list is empty and a default value is not specified, the function returns… Read More »List.First
Syntax List.ContainsAll(list as list, values as list, optional equationCriteria as any) as logical Description Indicates whether the list list includes all the values in another list, values. Returns true if value is found in the list, false otherwise. An optional equation criteria value, equationCriteria, can… Read More »List.ContainsAll
Syntax List.AnyTrue(list as list) as logical Description Returns true if any expression in the list list is true. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.AnyTrue
Syntax List.Accumulate(list as list, seed as any, accumulator as function) as any Description Accumulates a summary value from the items in the list list, using accumulator. An optional seed parameter, seed, may be set. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions /… Read More »List.Accumulate
Syntax List.SingleOrDefault(list as list, optional default as any) as any Description If there is only one item in the list list, returns that item. If the list is empty, the function returns null unless an optional default is specified. If there is more than one… Read More »List.SingleOrDefault
Syntax List.IsDistinct(list as list, optional equationCriteria as any) as logical Description Returns a logical value whether there are duplicates in the list list; true if the list is distinct, false if there are duplicate values. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions… Read More »List.IsDistinct
Syntax List.Product(numbersList as list, optional precision as nullable number) as nullable number Description Returns the product of the non-null numbers in the list, numbersList. Returns null if there are no non-null values in the list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions… Read More »List.Product
Syntax List.Sort(list as list, optional comparisonCriteria as any) as list Description Sorts a list of data, list, according to the optional criteria specified. An optional parameter, comparisonCriteria, can be specified as the comparison criterion. This can take the following values: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »List.Sort