CODEWITHSUNDEEP
powerbi
Dominic
Dominic

Reputation: 3

ISBLANK returns neither true or false

I have 2 important columns Destination Name is a custom column with a LOOKUPVALUE function. Which should return either a value, or BLANK. It is correctly returning these.

The second column, titled Column, is a custom column with an ISBLANK function which should return To Staff, or From Staff (True or False). depending on if the Destination Name is blank or not. It is returning True, False correctly, however, I am also getting several hundred blank rows. This is the same if using IF(Destination Name = "")

Using ISBLANK on Column, all of the blank rows are not recognised as being blank, which makes me believe they are an error. No documentation says what would make ISBLANK return an error.

Can anyone help?

Thanks Dom

Upvotes: 0

Views: 224

Answers (1)

msta42a
msta42a

Reputation: 3741

Check your source column, probably you have blank and null (empty) value in the column, and null is evaluated to null (visible blank in your results);

Upvotes: 0

Related Questions