Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

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...

 

PQ HELP.PNG
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! 🙂

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , see if approach of this blog can help

https://kohera.be/blog/power-bi/how-to-unpivot-twice/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
v-janeyg-msft
Community Support
Community Support

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:1.gif

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.

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!!


amitchandak
Super User
Super User

@Anonymous , see if approach of this blog can help

https://kohera.be/blog/power-bi/how-to-unpivot-twice/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.