Forum Discussion
How to perform multiple replacements of different values but with one value
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?
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.
3 Replies
- mahoneypat
Microsoft Employee
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
- ERD
Community Champion
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.
v-yingjlCommunity Support
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.
