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.
Hi guys,
I have 2 tables, table A hast 5 columns, table B 3 columns.
What I would like to do is to add the rows of table B into Table A; so that I can use one column to distinguish the varios kategories of my data within one column.
Anyone an idea how to achive that?
Best reagards,
Pete
Solved! Go to Solution.
Hello @Pete230 ,
You can use append queries, check this for instructions https://learn.microsoft.com/en-us/power-query/append-queries
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Works perfectly fine, my issue was, that the titels of the colums havent been exactly the same, that's why they have been writen beside the other columns not underneth.
But thank you, it workds now!
Hello @Pete230 ,
You can use append queries, check this for instructions https://learn.microsoft.com/en-us/power-query/append-queries
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
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 |
---|---|
110 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
104 | |
101 | |
80 | |
67 |