Forum Discussion

numersoz's avatar
numersoz
Icon for Helper III rankHelper 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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

numersoz what is the data type of this column? Is it a number? Change it to the number and then apply the conditional logic.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

numersoz's avatar
numersoz
Icon for Helper III rankHelper III
6 years ago

Above post solve the problem but not sure why the otherway didn't work.

The data type was a decimal number.