Forum Discussion
Solved
If Statement Calculated Column Returning Incorrectly
Hello everyone, Can someone please explain why the calculated column returns false instead of blank when the qty is between 4 and 7? Thank you.
Also, blank= false when converting data type from text to true/false.
So if you have this:
then convert the data type to true/false, everything is false:
djurecic
Super User
Super UserAlso, blank= false when converting data type from text to true/false.
So if you have this:
then convert the data type to true/false, everything is false:
Right, so if the column is a boolean data type, then blank() is treated as false because it's only two values (True/False). By having false() as one of the results of the if statement, this makes PowerBI think that the column is a boolean data type. Thank you for your help!
