concatenate values

[Anonymous]

I need to unite the values of fields of type text in two different tables, how can I do?

[qwertzuiop]

Hello there,

To connect my divisions, I use this. I wanted to share them with you.

Relation = [startLocation] & " ->" & [targetLocation)]

In addition, any string can be selected as the connection: Here ->

Cheers qwertzuiop

[MattAllington]

Well it depends. Are the tables related?  Are you writing a measure or a calc column?  Why do you want to do this - IE what are you trying to achieve and why?

[Anonymous]

The tables are related and I'm wanting to apply to a measure

[v-sihou-msft]

Hi vitexo87,

If these two tables are related, you can use LOOKUPVALUE() function to import the expected column into current table based on the related column. And concatenate it with existing column.

=CONCATENATE(table1[Column],

LOOKUPVALUE(table2[ExpectColumn],table2[RelatedColumn],table1[RelatedColumn])

)

Then involve this calculated column in your measure.

Reference:
LOOKUPVALUE Function (DAX)

CONCATENATE Function (DAX)

Regards,

[Anonymous]

What if I need to add a character in the middle of the information that will be formed, for example a "-"?

[v-sihou-msft · Accepted solution]

Hi @Anonymous,

You can nested CONCATENATE() within CONCATENATE() to add concatenate more characters you need.

CONCATENATE(string_expression,CONCATENATE(string_expression,string_expression))

Regards,

[DSimma]

I would usually just do the excel way ie. =(Value1)&" - "&(Value 2), I find it quicker and easier then using a function. 

[MattAllington]

Ok, you assuming you are writing a measure over your data table, you can use the RELATED() function to do what you want. https://msdn.microsoft.com/en-us/library/ee634202.aspx

If you are writing a measure over a lookup table, there is a RELATEDTABLE function, but this may be an issue as it will return multiple rows of data.