Combiner Functions Overview

Updated on

Discover Combiner Functions in Power Query M Language, vital for merging data from different sources in data manipulation tasks. This page provides a comprehensive list and descriptions of Combiner Functions available in the M Language.

Combiner Functions

FunctionDescriptionInputOutput
Combiner.CombineTextByDelimiterReturns a function that combines a list of text values into a single text value using the specified delimiter.TextFunction
Combiner.CombineTextByEachDelimiterReturns a function that combines a list of text into a single text using each specified delimiter in sequence.ListFunction
Combiner.CombineTextByLengthsReturns a function that combines a list of text into a single text using the specified lengths.ListFunction
Combiner.CombineTextByPositionsReturns a function that combines a list of text into a single text using the specified positions.ListFunction
Combiner.CombineTextByRangesReturns a function that combines a list of text into a single text using the specified positions and lengths.ListFunction
BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/combiner-functions