Forum Discussion

4 Replies

  • AlexanderPrime's avatar
    AlexanderPrime
    Solution Supplier

    Using Replace Values in Power Query you can use "null" as the replace with value and it won't break the number formating of the column, 

     

     

     

  • You could create a custom column which is null if the value of the base column is less than 0 else it is the current value of your base column. Then you can delete the base column and rename the new one.