Forum Discussion
Concatenate
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])
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
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
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)
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
