Syntax List.Difference(list1 as list, list2 as list, optional equationCriteria as any) as list Description Returns the items in list list1 that do not appear in list list2. Duplicate values are supported. An optional equation criteria value, equationCriteria, can be specified to control equality testing. Reference… Read More »List.Difference
Syntax List.Transform(list as list, transform as function) as list Description Returns a new list of values by applying the transform function transform to 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.Transform
Syntax List.Zip(lists as list) as list Description Takes a list of lists, lists, and returns a list of lists combining items at the same position. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions / List.Zip
Syntax List.RemoveNulls(list as list) as list Description Removes all occurrences of “null” values in the list. If there are no ‘null’ values in the list, 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 Functions / List.RemoveNulls
Syntax List.InsertRange(list as list, index as number, values as list) as list Description Returns a new list produced by inserting the values in values into list at index. The first position in the list is at index 0. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions… Read More »List.InsertRange
Syntax Lines.ToText(lines as list, optional lineSeparator as nullable text) as text Description Converts a list of text into a single text. The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference… Read More »Lines.ToText
Syntax Lines.FromBinary(binary as binary, optional quoteStyle as nullable number, optional includeLineSeparators as nullable logical, optional encoding as nullable number) as list Description Converts a binary value to a list of text values split at lines breaks. If a quote style is specified, then line breaks… Read More »Lines.FromBinary
Syntax Lines.FromText(text as text, optional quoteStyle as nullable number, optional includeLineSeparators as nullable logical) as list Description Converts a text value to a list of text values split at lines breaks. If includeLineSeparators is true, then the line break characters are included in the text.… Read More »Lines.FromText
Syntax Lines.ToBinary(lines as list, optional lineSeparator as nullable text, optional encoding as nullable number, optional includeByteOrderMark as nullable logical) as binary Description Converts a list of text into a binary value using the specified encoding and lineSeparator.The specified lineSeparator is appended to each line. If… Read More »Lines.ToBinary
Syntax Function.Invoke(function as function, args as list) as any Description Invokes the given function using the specified list of arguments and returns the result. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Function Values / Function.Invoke