cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
numersoz
Helper III
Helper III

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 treshhold I set them to zero. But there are also null values. So I do an if elsestatement for null = null. 

But I can error for the rows which contain null. I have to replace errors and make them null again. Is there an another approch to this so I don't get errors?

 

Capture.JPG

 



1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @numersoz ,

 

Try this:

Capture.PNG

 

If you start comparing anything with null you get errors.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

5 REPLIES 5
parry2k
Super User
Super User

@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!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





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

The data type was a decimal number.

camargos88
Community Champion
Community Champion

Hi @numersoz ,

 

Try this:

Capture.PNG

 

If you start comparing anything with null you get errors.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Hi,

 

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

@numersoz ,

 

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

So start checking the null values.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors