Concatenate two columns from different tables

[Anonymous]

Hi, 

I am trying to concatenate(distinct) two column from different tables.

I have tried following and other similar expressions: Column  = CONCATENATE(Table1[column], RELATED(Table2[column])) but I am getting same error message (se picture below). 

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. 

Many Thanks

[Ashish_Mathur]

Hi,

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

[Anonymous]

Hi @Anonymous ,

Inorder to achive this you need a relationships between these two tabbles.

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

Thanks,

Tejaswi