merge two or more columns from one table or different tables into a new column of a new table

[Anonymous]

Hello. I want to create a column to show in report graphs that combines values from two different columns. How should I proceed? By creating a calculated measure or column? Can you write me a code example or step to follow to do this?

I have a table called "ABCSupplier" with individual columns that I want to merge and have them appear merged in the new measure or calculated column or in a new table. How do I do this?

Thanks!

[Anonymous]

Thank you all, i wil try this solution! 

[Anonymous · Accepted solution]

Hi @Anonymous ,

First of all, many thanks to @Ritaf1983  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Create the new column to merge two tables column.

Merge = 'Table 2'[Nome Diretor] & "-" & RELATED('Table 1'[Pedido])

3.The result is shown below.

Besides, you can also try to use merge feature in the Power query editor.

Merge queries overview - Power Query | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @Anonymous

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523