Syntax List.Single(list as list) as any Description If there is only one item in the list list, returns that item. If there is more than one item or the list is empty, the function throws an exception. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »List.Single
Syntax List.Modes(list as list, optional equationCriteria as any) as list 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.Modes
Syntax List.Buffer(list as list) as list Description Buffers the list list in memory. The result of this call is a stable list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Buffer
Syntax List.MaxN(list as list, countOrCondition as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as list Description Returns the maximum value(s) in the list, list. After the rows are sorted, optional parameters may be specified to further filter the result. The optional parameter,… Read More »List.MaxN
Syntax List.IsEmpty(list as list) as logical Description Returns true if the list, list, contains no values (length 0). If the list contains values (length > 0), returns false. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.IsEmpty
Syntax List.ReplaceValue(list as list, oldValue as any, newValue as any, replacer as function) as list Description Searches a list of values, list, for the value oldValue and replaces each occurrence with the replacement value newValue. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions… Read More »List.ReplaceValue
Syntax List.Reverse(list as list) as list Description Returns a list with the values in the list list in reversed order. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Reverse
Syntax List.RemoveItems(list1 as list, list2 as list) as list Description Removes all occurrences of the given values in the list2 from list1. If the values in list2 don’t exist in list1, the original list is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List… Read More »List.RemoveItems
Syntax List.Dates(start as date, count as number, step as duration) as list Description Returns a list of date 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.Dates
Syntax List.Distinct(list as list, optional equationCriteria as any) as list Description Returns a list that contains all the values in list list with duplicates removed. If the list is empty, the result is an empty list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List… Read More »List.Distinct