Forum Discussion

damilolaA's avatar
damilolaA
Regular Visitor
1 year ago
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.   
  • djurecic's avatar
    djurecic
    11 months ago

    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's avatar
djurecic
Icon for Super User rankSuper User
11 months ago

Just checking- is Qty datatype text?

  • damilolaA's avatar
    damilolaA
    Regular Visitor
    11 months ago

    It was already formatted as a  whole number in Power Query