Create new table with 2 columns from other tables

[Zilver]

Hi all

I have 2 diffrent tables and each table have 2 columns like this :

Table 1:

Column A	Column B
111	F
222	F
333	D

Table 2:

Column G	Column W
555	P
777	Q
999	Q

and I want to merge their values in 1 table like this :

ID Number	Code
111	F
222	F
333	D
555	P
777	Q
999	Q

please I need help to do that and thanks all.

[Mariusz · Accepted solution]

Hi @Zilver 

You can use Append in Power Query, but you need to change the Column Names to match first.

You can do it as well using DAX Table Expression like below 

DAX Union = 
UNION( 
    'Table 1',
    'Table 2'
) 

Please see the attached file with solutions.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Zilver]

Done you are the best and I really appreciate it. Thanks a lot