Forum Discussion
How to replace several values in a column for a single value (POWER BI QUERY)
Hi,
I have more than 500 different values in a column and I need to replace all of them for a single value in a new column. How can I do that easily? Is there such a function as replace all values except blank, for a unique value?
Thanks, RA
hi Anonymous
try calculated column
Column = IF( isBlank('Table'[Field]);blank();"YourNewValue") )do not hesitate to give a kudo to useful posts and mark solutions as solution
hi Anonymous
it should work
= if [Column1] = null then null else "YourValue"do not hesitate to give a kudo to useful posts and mark solutions as solution
6 Replies
hi Anonymous
try calculated column
Column = IF( isBlank('Table'[Field]);blank();"YourNewValue") )do not hesitate to give a kudo to useful posts and mark solutions as solution
hi Anonymous
it should work
= if [Column1] = null then null else "YourValue"do not hesitate to give a kudo to useful posts and mark solutions as solution
- Go to power query editor - -> take duplicate of your required column - -> then right on that duplicate column - -> select replace option and enter needed value of yours - -> click OK.
Please don't forget to give Kudos and accept this as a solution if it helps you.
