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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Trying to remove nulls from different columns without removing the actual data

I have created an append as new query and pulled in 3 separate queries to create this one. The problem is that in the append query where the columns exist that dont exist in one of the other queries I have null values. How do I remove the null values but keep the data in the column that actually exist? So in the first 2 columns I have data and the next 5 columns show null. but when you scroll down the first 2 columns start showing null and the next 5 start showing data. And I need to remove the nulls in all the columns and essentially "move the data up".,.... if that makes sense?https://1drv.ms/u/s!AoAH5jE4U-XZhCi88Hfm97BN8uXN?e=zzfs3R 

2 REPLIES 2
sturlaws
Resident Rockstar
Resident Rockstar

@Anonymous ,

 

the file you have linked to, prompts me to update data when I open it, which fails as I obviously don't have the necessary credentials

 

Cheers,
Sturla

Anonymous
Not applicable

I apologize. I linked it through one drive. I found the answer after posting and then researching like Nathaniel suggested from a previous post. Thank you anyway for trying to take a look at it. I am very new to power bi and dont know all the nuances of posting in the forum.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

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.