Syntax List.Average(list as list, optional precision as nullable number) as any Description Returns the average value for the items in the list, list. The result is given in the same datatype as the values in the list. Only works with number, date, time, datetime, datetimezone… Read More »List.Average
Syntax List.Contains(list as list, value as any, optional equationCriteria as any) as logical Description Indicates whether the list list contains the value value. Returns true if value is found in the list, false otherwise. An optional equation criteria value, equationCriteria, can be specified to control… Read More »List.Contains
Syntax List.ReplaceRange(list as list, index as number, count as number, replaceWith as list) as list Description Replaces count values in the list with the list replaceWith, starting at specified position, index. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.ReplaceRange
Syntax List.Times(start as time, count as number, step as duration) as list Description Returns a list of time values of size count, starting at start. The given increment, step, is a duration value that is added to every value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »List.Times
Syntax List.MatchesAny(list as list, condition as function) as logical Description Returns true if the condition function, condition, is satisfied by any of values in the list list, otherwise returns false. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.MatchesAny
Syntax List.StandardDeviation(numbersList as list) as nullable number Description Returns a sample based estimate of the standard deviation of the values in the list, numbersList. If numbersList is a list of numbers, a number is returned. An exception is thrown on an empty list or a… Read More »List.StandardDeviation
Syntax List.MatchesAll(list as list, condition as function) as logical Description Returns true if the condition function, condition, is satisfied by all values in the list list, otherwise returns false. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.MatchesAll
Syntax List.Random(count as number, optional seed as nullable number) as list Description Returns a list of random numbers between 0 and 1, given the number of values to generate and an optional seed value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions /… Read More »List.Random
Syntax List.Covariance(numberList1 as list, numberList2 as list) as nullable number Description Returns the covariance between two lists, numberList1 and numberList2. numberList1 and numberList2 must contain the same number of number values. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Covariance
Syntax List.Max(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any Description Returns the maximum 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.Max