Forum Discussion
Anonymous
6 years agoNot applicable
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 fi...
- 6 years ago
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
Anonymous
6 years agoNot applicable
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
6 years agoResponsive Resident
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
- Anonymous6 years agoNot applicable
I was able to get that to work. Thank you!