DAX measure to concatenate values of a row and text

[Anonymous]

Hello everybody, 

I would like to write a DAX query by Concatenating values from other columns in the same row + text.  I would like to create something like the last column (Message). 

Basically something like - "Steph is " [direction] [difference %] " from yesterday,  "James is " [direction] [difference %] " from yesterday, "Paul is " [direction] [difference %] " from yesterday. 

Is it possible to do it in the same DAX measure? and if so, can you please give any suggestions.  Counting on you guys.

[TomMartens · Accepted solution]

Hey,

using this DAX statement to create a calculated column

Text Concat = 
"At " & 'ProductCatalog'[PriceDate] & " the Price was " & 'ProductCatalog'[Price]

creates this:

I guess the secret sauce is just the & sign to concatenated as many strings as you need and the referencing the columns in you table like so 'yourtablename'[column1]

Hopefully this is what you are looking for

Regards

Tom

[Anonymous · Accepted solution]

Hey @Anonymous,

I would recommend a calculated column which would be calculated by:

column =

IF(

   Table[difference] > 0,   

   COMBINEVALUES(" ", COMBINEVALUES(" is up ", Table[name], Table[direction]), "from yesterday"),

   COMBINEVALUES(" ", COMBINEVALUES(" is down ", Table[name], Table[direction]), "from yesterday")

)

Hope this works for you,

Parker

[JoeRobert06]

Can this be performed as a measure?

[renoyzac]

Does anyone know how to concatenate the row and text in a measure? 

[TomMartens]

Hey @renoyzac ,

please be a little more specific on your requirements. The simple answer is: yes, of course!

But then, you have to consider how you want to use this, meaning the combination of visual and measure. This is important, e.g., using the table iterator function CONCATENATEX( ... ) might create "long" strings on the Total line.

I think it's a good idea to start your own thread providing a more detailed description of your requirements and ideally a link that points to pbix file on onedrive or dropbox, that contains sample data but still reflects your data model.

Regards,

Tom

[TomMartens · Accepted solution]

Hey,

using this DAX statement to create a calculated column

Text Concat = 
"At " & 'ProductCatalog'[PriceDate] & " the Price was " & 'ProductCatalog'[Price]

creates this:

I guess the secret sauce is just the & sign to concatenated as many strings as you need and the referencing the columns in you table like so 'yourtablename'[column1]

Hopefully this is what you are looking for

Regards

Tom