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?
Solved! Go to Solution.
@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!
That's because if you compare null with any value, you are gonna get error.
So start checking the null values.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.