Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Concatenate Values

Hi Experts

 

Is it possible to concatentate three measure to produce the following output...

 

Measure 1 (measure 2, Measure 3)

11.82 (11.32, 12.45)

so the above is my result in power BI.

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous , try this DAX measure:

     

    Combined Measure = 
VAR Part1 = [Measure 1]
VAR Part2 = [Measure 2]
VAR Part3 = [Measure 3]
VAR Result = 
	Part1 
	& " ("
	& Part2
	& ", "
	& Part 3
	& ")"
RETURN
Result

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You can concatenate within a concatenate, if that's whatyour asking.

     

    Can you show the data you wan't to get that ouput from?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous , try this DAX measure:

     

    Combined Measure = 
VAR Part1 = [Measure 1]
VAR Part2 = [Measure 2]
VAR Part3 = [Measure 3]
VAR Result = 
	Part1 
	& " ("
	& Part2
	& ", "
	& Part 3
	& ")"
RETURN
Result
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      many thanks Chris....Excellent feedback. Works prefectly.