Syntax List.NonNullCount(list as list) as number Description Returns the number of non-null items in the list list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.NonNullCount
Syntax List.Mode(list as list, optional equationCriteria as any) as any Description Returns the item that appears most frequently in the list, list. If the list is empty an exception is thrown. If multiple items appear with the same maximum frequency, the last one is chosen.… Read More »List.Mode
Syntax List.Skip(list as list, optional countOrCondition as any) as list Description Returns a list that skips the first element of list list. If list is an empty list an empty list is returned. This function takes an optional parameter, countOrCondition, to support skipping multiple values… Read More »List.Skip
Syntax List.Durations(start as duration, count as number, step as duration) as list Description Returns a list of count duration values, starting at start and incremented by the given duration step. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Durations
Syntax List.Generate(initial as function, condition as function, next as function, optional selector as nullable function) as list Description Generates a list of values given four functions that generate the initial value initial, test against a condition condition, and if successful select the result and generate… Read More »List.Generate
Syntax List.RemoveRange(list as list, index as number, optional count as nullable number) as list Description Removes count values in the list starting at the 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.RemoveRange
Syntax List.Select(list as list, selection as function) as list Description Returns a list of values from the list list, that match the selection condition selection. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Select
Syntax List.DateTimeZones(start as datetimezone, count as number, step as duration) as list Description Returns a list of datetimezone 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.DateTimeZones
Syntax List.Repeat(list as list, count as number) as list Description Returns a list that is count repetitions of the original list, list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Repeat
Syntax List.Combine(lists as list) as list Description Takes a list of lists, lists, and merges them into a single new list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Combine