cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aharris15
Regular Visitor

Filling null cells from a different column

I'm new to Power Query and PowerBI and feel like this should be relatively simple but I haen't figured it out quite yet.

 

I have an incomplete column of data that has some null cells. I want to fill the null cells in Column A with the values in Column B, but only the null cells. If the cells in Column A have a value, I want to keep those values. And furthermore, if Column B happens to be null as well, how do you get it to get the value from Column C?

 

Update: I've tried setting up a conditional column as shown below but I don't think its recognizing the null values because it just returns the column I have setup in the Else condition and I still have the nulls.

 

PowerBI Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
gpoggi Resolver II
Resolver II

Re: Filling null cells from a different column

Yep, you are using space " " and blank doesn't have spaces, so try to compare to nothing between quotes "" it should work.

 

Any question, just let me know.

 

Regards,

 

Gian Carlo Poggi

View solution in original post

4 REPLIES 4
Highlighted
gpoggi Resolver II
Resolver II

Re: Filling null cells from a different column

Hi aharris15, your conditional column setup seems to be ok, and other way to get the Columns C value when Column B is null is creating a Custom Column with this code:

if

  [Column A] = null

then

  if

    [Column B] = null

  then

    [Column C]

  else

    [Column B]

else

  [Column A]


This should work, but one question regarding your conditional column, it should work as it is, so maybe the problem is about your nulls, did you confirm that Column A contains nulls instead of (blank) values? if you did, Could you send a sample of your data so we can help you to figure it out what is going on?

 

Regards,

 

Gian Carlo Poggi

aharris15
Regular Visitor

Re: Filling null cells from a different column

So my cells are actually blank - they do not have null in them. I tried putting " " instead of null but still no luck. Is there something else I need to put there instead?

gpoggi Resolver II
Resolver II

Re: Filling null cells from a different column

Yep, you are using space " " and blank doesn't have spaces, so try to compare to nothing between quotes "" it should work.

 

Any question, just let me know.

 

Regards,

 

Gian Carlo Poggi

View solution in original post

aharris15
Regular Visitor

Re: Filling null cells from a different column

I was able to get that to work. Thank you!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors