Forum Discussion
AlanP514
3 years agoPost Patron
Replacing 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
- AlexanderPrimeSolution 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.