how to combine two or three columns to one new table

[jack_lai_1117]

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 !!

[jack_lai_1117]

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

Now I have result what I want .

[v-jayw-msft]

Hi @jack_lai_1117 ,

Check the union function.

https://docs.microsoft.com/en-us/dax/union-function-dax 

new table = Union(Table1,Table2)

Best Regards,

Jay

[PaulDBrown · Accepted solution]

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