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 !!
Solved! Go to Solution.
In Power Query, use the Append function. In DAX use UNION
Proud to be a Super User!
Paul on Linkedin.
After I try your method , it is worked ~~~~
Now I have result what I want .
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
In Power Query, use the Append function. In DAX use UNION
Proud to be a Super User!
Paul on Linkedin.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
75 | |
72 | |
48 | |
47 |
User | Count |
---|---|
160 | |
85 | |
80 | |
68 | |
67 |