The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I would want to concatenate 2 columns from 2 different tables. example below:
Table A
Table B
i would like to combine the Sequence Number (Table A) and Region Overall (Table B). What syntax would i need to do? sample output below.
Solved! Go to Solution.
@Anonymous , You need to merge these tables in the power query and then create a new column
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
or
You can copy one column value from one Table to another
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
@Anonymous , You need to merge these tables in the power query and then create a new column
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
or
You can copy one column value from one Table to another
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8