COMBINEVALUES DAX Function in Power BI

The COMBINEVALUES function in DAX is used to concatenate values (combine multiple column or expression values into a single text string) with a specified delimiter.

DAX Syntax COMBINEVALUES(delimiter, expression, expression[, expression]…)

The function has the following parameters:

delimiter: The separator we want between values (e.g., " - ", "|", ",", "" for none).
expression: A DAX expression whose value will be joined into a single text string.

Return value: It returns a concatenated string.

Example:

DAX

COMBINEVALUES Column =
COMBINEVALUES (
    ",",
    'Branch details'[Branch],
    'Branch details'[ID No],
    'Branch details'[Branch specific sum]
)

The output of the above code is shown below:

Points to remember:

Only works with text output.
All expressions are implicitly converted to text.

Previous Next