Concatenate

[pedroccamaraDBI]

Hi everyone,
Is there a way of joinning 2 columns from different tables, but related? I'd like to concatenate prodCode from Tab Sales with product from Tab Products.
Can you help?
Thanks in advance
Pedro

[AliceW · Accepted solution]

If they are related  through a one-to-many connection (say table A annd table B), go to the B table and add a new column:

Concatenate = 'B table'[column1] && related(A table[column2])

[AliceW · Accepted solution]

If they are related  through a one-to-many connection (say table A annd table B), go to the B table and add a new column:

Concatenate = 'B table'[column1] && related(A table[column2])

[FarhanAhmed]

Create a reference column in your table of 2nd table using 

Reference Column = RELATED (Base Column)

add new column by using Concatenate function thru DAX 

https://docs.microsoft.com/en-us/dax/concatenate-function-dax

[pedroccamaraDBI]

Hey @FarhanAhmed
I've tried to add that column, on the products table, cose in sales table i only have product code, and i want to see the name of the products and i couldn't because it "asks" me the column name....not a table and column name, you know?
Am i doing something wrong? (dum question)
 

[FarhanAhmed · Accepted solution]

Since Product contains 1 Value and Sales Contains Multiple Values therefore Reference Column will be created on Many Side because it will return 1 value from product. In this case you should create column in Sales Table rather than in Product Table. 

Rule of thumb, reference column will always create on Many Side