If ISBLANK, NULL or EMPTY in power query

This thing with how Power Query handles nulls, blanks or empty drove me nuts when I was a beginner and still today I manage to forget about it, so here is a video for how to manage them in case you struggle also with it.

In this video, I will show you how to to is blank in power query. If you are trying to do fill down with empties or nulls, check this video instead:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

[twitno]

Thank you so much for this Curbal, it drove me nuts, too, trying to get PQ to handle empty cells.

[shubhamsanas]

Thankyou for an eye opening video, I highly appreciate you for covering the best info in this one video...!

[agavosagricola]

You rock!, Thank you. I lost a lot of hours trying to fix this, and you gave me the answer in just 3 minutes.

[niteeshmishra]

Thank you very much, you saved me from losing my job, greetings with love from India.

[jonathankemp]

Thanks, that's definitely annoying. You saved me a lot time.

[Chaeon]

LOVE your videos! These are the reason, I still have a job!

[hannes.mutala]

After few hours searching the solution to my problem, this short video of yours brought it to me. Thanks.

[rlei]

indeed, this 'null' thing has troubled me for days! thanks

[francescacolonnello]

Thank you for pointing this out, it drove me crazy too as it was preventing the Fill feature in Power Query to work as expected!

[pepmartimascaromonserrat]

Thank you! I'm just starting with Power Queries and I found this very helpful

[vladimirkostic]

Thank you for your videos! Always save me when I'm in a limbo with silly things like these.

[joseagundis]

Son de los casos más comunes que nos enfrentamos en Consultas, gracias por compartir Ruth.

[eszterpetrasitz]

Thank you for the idea. I had a cell with numbers in it so originally null was there instead of blank but it didn't work. It didn't accept null as input, it had to be number. But this video was still useful. It gave me an idea. Since I knew that the numbers must always be positive, I've changed null to -1 and it worked that way. Maybe not the nicest solution though. Thanks again for the inspiration.

[faresf]

I wasted 2 hrs trying to make workarounds. Thanks for the video.

[susanotchere]

Thank you for this quick and excellent explanation!🎉

[vancehuynh]

you made my day. I was going crazy with this problem

[tonyandlisab]

Thanks for the tip and keep up the posts - there is so much to learn, I am slowly coming to the conclusion that no matter what you need to do with Power Query then there is a way to do it (you just need to know where to look/who to listen to...)

[danielbotero]

Was struggeling for this problem like 15 hours of work... Thanks for the tip

[EricaDyson]

And it has just happened to me and I couldn't figure out why. Now I know!! As ever, you've helped me out!

[VivekananthRadhakrishnan]

You are so beautiful and expressive and also address all the problems i face in Power query like magic