- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power Query transformation - Append columns within ONE query
Hi there,
I have data organised a bit like this - I just want to take the last three columns and place them directly underneath the first three, like this...
Though I don't want to create two seperate queries and append them! For the real life problem this would mean creating a huge amount of individual queries
Any ideas most appreciated! 🙂
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , see if approach of this blog can help
https://kohera.be/blog/power-bi/how-to-unpivot-twice/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Anonymous
I have a simple method, just duplicate a table, delete the merged rows in the corresponding table, change the name, and append queries.
Like this:
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello! I have a problem in data visualization, which I would like to see if they would know how to help me. I joined the tables as Janey did: let's imagine that I have two columns that are the ones that interest me for my table: Module the first, where there are different modules that are the ones that I appended from different tables and STATUS that is the status they carry, it can be completed, approved, on hold.. and so on. My problem is that when I make the table, I get blank values that I can't convert to 0. My table has rows to Module "ec", "comp", "lms" and columns to my states "completed", "approved", "on hold" and values generate a measure that is:
calculate(counta("annex"[status])) +0. And the most zero doesn't work for me! It continues to show blank values in the table. And this happens to me because I don't have a status for certain modules. So in the database this would give you BLANK. Help please!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , see if approach of this blog can help

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-01-2024 06:44 PM | |||
06-04-2024 01:21 PM | |||
Anonymous
| 02-28-2024 12:43 AM | ||
04-24-2024 03:16 AM | |||
Anonymous
| 01-12-2024 02:28 PM |
User | Count |
---|---|
134 | |
124 | |
84 | |
61 | |
46 |