Concatenate two columns from different tables

Question

Hi,&nbsp;&nbsp;I am trying to concatenate(distinct) two column from different tables.I&nbsp;have tried following and other similar expressions: Column&nbsp; = CONCATENATE(Table1[column], RELATED(Table2[column]))&nbsp;but I am getting same error message (se picture below).&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In the picture below you can see what I try to accomplish, and a drawing of the relationship between the tables.Left is a Power BI table visualisation of the coulmns i want to concatenate and right is the wished result. I have a fact table, and two dimensions.&nbsp;&nbsp;Many Thanks&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Inorder to achive this you need a relationships between these two tabbles.&nbsp;You can refer this post. May be it is useful.https://community.powerbi.com/t5/Desktop/how-to-concatenate-two-fields-of-different-data-formats-and/td-p/32338&nbsp;Thanks,Tejaswi&nbsp;

ashish_mathur · Answer

Hi,
You will have to write that as a measure using the CONCATENATEX() function.

Forum Discussion

Concatenate two columns from different tables

2 Replies

Related content

Concatenate 3 columns

Concatenating columns from different tables

create custom column concatenated

Power query - concatenate text columns

how to concatenate two columns from two different tables