Forum Discussion
Nulls in Columns
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?
Hi Anonymous ,
I have to go off line, so I would like to suggest that you would repost this again with your pbix as people usually look first at posts that have zero replies.
To post a pbix, share it to one drive or dropbox, something like that. You will get a hyperlink which you can insert by using the link symbol shown in the picture. The next step down is to copy and paste into the message as we can copy and paste right into Power BI.
Good Luck!
Nathaniele
6 Replies
Hi Anonymous ,
You might look at merging rather than appending the data. On the other hand if you can publish your pbix and show us what you had originally, and where you are trying to go, the forum may be able to help you.
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks,Nathaniel
Hi Anonymous ,
I have to go off line, so I would like to suggest that you would repost this again with your pbix as people usually look first at posts that have zero replies.
To post a pbix, share it to one drive or dropbox, something like that. You will get a hyperlink which you can insert by using the link symbol shown in the picture. The next step down is to copy and paste into the message as we can copy and paste right into Power BI.
Good Luck!
Nathaniele