I want to seach and rename data in a column

[klb0066]

For example, I have lots of data in a column and would like to rename all data that contains ENG to Engineering, OP to Operations, MNT to Maintenance, everthing else to Other. How do I begin this?

[DataNinja09]

You have to open "Edit Queries" (Power QUery) and there is a button "replace value" available there.

Then you hit "Close and Apply"

[klb0066]

I don't want to necessarily replace them, I just want to group them so I can use that new column as a filter to drill down.

[DataNinja09]

Then you should probably use CONTAINS in a calculated column.

https://community.powerbi.com/t5/Desktop/If-text-column-CONTAINS-specified-value-give-me-what-I-want...

[klb0066]

I have tried this. text.contain creates an error. I cannot figure it out

[DataNinja09]

Could you show a sample of your data, specify your data types and the error message that you get ?

[klb0066]

This is the column i want to pull out key parts such as "OP" and create a splicer with the title OPerations. So when Operations is selected, it will display all of the names that contain OP

[v-yulgu-msft · Accepted solution]

Hi @klb0066,

You can add a conditional column in Query Editor.

Best regards,

Yuliana Gu