Solved: how to combine two or three columns to one new tab...

Anonymous · ‎03-20-2022

Hi all :

I have more than two column need to combine to a new table , but , I only found "how to merge " not how to combine .

Fo example , column-A has 3 rows data column-B has 3 rows data , and I want to merge to a new table with one column and 6 rows data in this !!!

How colud I do this !!

PaulDBrown · ‎03-20-2022

In Power Query, use the Append function. In DAX use UNION

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Anonymous · ‎03-24-2022

After I try your method , it is worked ~~~~

Now I have result what I want .

v-jayw-msft · ‎03-24-2022

Hi @Anonymous ,

Check the union function.

new table = Union(Table1,Table2)

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

PaulDBrown · ‎03-20-2022

In Power Query, use the Append function. In DAX use UNION

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

how to combine two or three columns to one new table