Forum Discussion

numersoz's avatar
numersoz
Helper III
6 years ago
Solved

Power Query Conditional Column with NULL Values

Hi, I need to clean up sensor data. I know that if the sensor data is a negative number or below a certain treshhold, it should be zero. I do this with a conditional column, if below the treshh...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi numersoz ,

     

    Try this:

     

    If you start comparing anything with null you get errors.

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi numersoz ,

 

Try this:

 

If you start comparing anything with null you get errors.

  • numersoz's avatar
    numersoz
    Helper III
    6 years ago

    Hi,

     

    Thank you this did solve the problem. I am not sure why the otherway didn't work.

    • camargos88's avatar
      camargos88
      Community Champion
      6 years ago

      numersoz ,

       

      That's because if you compare null with any value, you are gonna get error. 

      So start checking the null values.