Forum Discussion

Post Patron

3 years ago

Solved

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

Need Help

Show and Tell

Tips and Tricks

johnt75
3 years ago

johnt75

Super User

3 years ago

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.

AlanP514
Post Patron
3 years ago
Could you please show one demo
- johnt75
  Super User
  3 years ago

Forum Discussion

Replacing numerical values with text values

Related content

Replacing values with Iterations

replace numeric values with 0 in Power Query

Replace numeric values with NULL in power query

Replace Errors values with Null values

Replace values