PowerBI - referencing an empty string, or a Null inside of a DAX formula

[Isaac]

Hello,

How would I reference a zero-length string/empty string, inside of PowerBI? Is it two double quotes like Excel, "", or is it two single quotes like sql server, ''
etc?

Also, if I'm trying to write a formula condition for a calculated column, and I also need to refer to if the source column might be NULL.
Do I just write Null or do I reference it another way?

 

[Isaac]

Okay, I think I figured that for Null I need to use ISBLANK and for a ZLS I can do two double quotes. ""

 

[theDBguy]

You can also use the LEN() function.

 

[Isaac]

You can also use the LEN() function.

I assume that Len() coerces a null into something that can be evaluated for length?

 

[theDBguy]

I assume that Len() coerces a null into something that can be evaluated for length?

Yes, it should.

 

[Isaac]

Thank you