Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 e...
Need Help
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago
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.