The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 @Anonymous ,
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.
User | Count |
---|---|
65 | |
61 | |
60 | |
53 | |
27 |
User | Count |
---|---|
181 | |
88 | |
70 | |
48 | |
46 |