Forum Discussion
AlanP514
Post Patron
Post PatronReplacing numerical values with text values
Hi All, I want to Replace these -2 values with N/A, Is there any possible way to replace numerical values with text as N/A values
Thanks
Alan p James
4 Replies
- 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,
johnt75Super User
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.
