Syntax Combiner.CombineTextByDelimiter(delimiter as text, optional quoteStyle as nullable number) as function Description Returns a function that combines a list of text into a single text using the specified delimiter. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Combiner Functions / Combiner.CombineTextByDelimiter
Syntax Combiner.CombineTextByEachDelimiter(delimiters as list, optional quoteStyle as nullable number) as function Description Returns a function that combines a list of text into a single text using each specified delimiter in sequence. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Combiner Functions / Combiner.CombineTextByEachDelimiter
Syntax Combiner.CombineTextByPositions(positions as list, optional template as nullable text) as function Description Returns a function that combines a list of text into a single text using the specified positions. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Combiner Functions / Combiner.CombineTextByPositions
Syntax Combiner.CombineTextByLengths(lengths as list, optional template as nullable text) as function Description Returns a function that combines a list of text into a single text using the specified lengths. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Combiner Functions / Combiner.CombineTextByLengths
Syntax Combiner.CombineTextByRanges(ranges as list, optional template as nullable text) as function Description Returns a function that combines a list of text into a single text using the specified positions and lengths. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Combiner Functions / Combiner.CombineTextByRanges
Syntax BinaryFormat.Group(binaryFormat as function, group as list, optional extra as nullable function, optional lastKey as any) as function Description The parameters are as follows: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.Group
Syntax BinaryFormat.Text(length as any, optional encoding as nullable number) as function Description Returns a binary format that reads a text value. The length specifies the number of bytes to decode, or the binary format of the length that precedes the text. The optional encoding value… Read More »BinaryFormat.Text
Syntax Table.Partition(table as table, column as text, groups as number, hash as function) as list Description Partitions the table into a list of groups number of tables, based on the value of the column and a hash function. The hash function is applied to the… Read More »Table.PartitionValues
Syntax Binary.FromList(list as list) as binary Description Converts a list of numbers into a binary value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / Binary.FromList
Syntax BinaryFormat.Decimal(binary as binary) as any Description A binary format that reads a .NET 16-byte decimal value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.Decimal