Forum Discussion

Solution Sage

8 years ago

Solved

Power Query - Replace multiple substrings in one column

Hello, I am looking for a solution to replace multiple substrings at once. For Example: Category Category after AA_A AB_A aa_B AB_B AA_C AB_C BB_A DE_A BB_B DE_B BB_C...

Need Help

v-yulgu-msft
8 years ago
Hi Floriankx,

Here are some blogs written about multiple replacements of words with Power Query:
Multiple replacements or translations in Power BI and Power Query
Multiple replacements of words in Power Query
Replace multiple values in a single step

Regards,
Yuliana Gu

v-yulgu-msft

Microsoft Employee

8 years ago

Hi Floriankx,

Here are some blogs written about multiple replacements of words with Power Query:

Multiple replacements or translations in Power BI and Power Query

Multiple replacements of words in Power Query

Replace multiple values in a single step

Regards,

Yuliana Gu

Forum Discussion

Power Query - Replace multiple substrings in one column

Related content

Find multiple substring DAX CONTAINSSTRING

Power Query - Replace multiple substrings in one list column

how to dynamically replace values for multiple columns

Table Replace Value multiple condition

Power Query - Replace multiple substrings in one column