Forum Discussion
Solved
Create new table with 2 columns from other tables
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 ...
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
Mariusz
Community Champion
Community ChampionHi 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
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Done you are the best and I really appreciate it. Thanks a lot