Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i want to merge 2 tables and i want the result as described in the photo
kind regards
Solved! Go to Solution.
Hey,
the Append transformation actually does what you are looking for except that you will loose the "row headers" of the second table. Maybe this gets you started:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
If the article does not solve your question, please consider to create a pbix file that contains sample data, upload the file to onedrive or dropbox and share the link.
Regards,
Tom
Hey,
from inside the QueryEditor you can use the "Append" function in the "Combine" ribbon of the Home menu.
Hopefully this is what you are looking for.
Regards,
Tom
And how can i put them beneath each other.
If you want your rows to be sequenced in a specific manner, try adding an index column after appending.
Hey,
the Append transformation actually does what you are looking for except that you will loose the "row headers" of the second table. Maybe this gets you started:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
If the article does not solve your question, please consider to create a pbix file that contains sample data, upload the file to onedrive or dropbox and share the link.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |