Forum Discussion
arvindarvind24
4 years agoHelper II
Concatenate two data from different tables without reference
Concatenate two data from different tables without reference Sample data and output Style No.(Table1) Region(Table2) Concatenate(Output) ABCD03700I BIHAR ABCD03700I,BIHAR ABCD06299 BL...
- 4 years ago
arvindarvind24 , crossjoin
new table = Crossjoin(Table1, Table2)
or
new table = addcolumns(Crossjoin(Table1, Table2) , "Concat", [Style No] & ", " & [Region])
- 4 years ago
Hi arvindarvind24
Here is a sample file with the solution https://we.tl/t-IHBj2FTgwNConcatenated Table = SELECTCOLUMNS ( GENERATE ( Table1, ADDCOLUMNS ( Table2, "@Concatenate", Table1[Style No.] & "," & Table2[Region] ) ), "Concatenate", [@Concatenate] )
Arul
4 years agoSuper User
you can also try to merge the tables in Power Query Editor as mentioned in the below community thread.
https://community.powerbi.com/t5/Desktop/Concatenate-String-Fields-From-Different-Tables/m-p/1425618
Thanks,
Arul