How to perform multiple replacements of different values but with one value

[Novice_]

I have read a few posts about the same but I'm finding it difficult to work. How do I replace multiple values of the same content but each written in different font and style with one value? 

Please refer to the folllowing table for the problem:

Amino 1

AmIN One

AMEN ONE

AMINO one

Amen-1

I want to replace all these values with just Amen-1. How do I do this without having to use Replace Values for every single value in M script/Power Query Editor?

[v-yingjl · Accepted solution]

Hi @Novice_ ,

Just change the parameter about the replace query like this:

= Table.ReplaceValue(#"Changed Type",each [Column1],"Amen-1",Replacer.ReplaceText,{"Column1"})

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ERD]

Hi @Novice_ ,

This article might help you: Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold .

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[mahoneypat]

Creating a Groups column is one easy way to handle this on the DAX side after your data are loaded.

Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs

Pat