cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
great_AS Member
Member

EDIT QUERY bulk replace

Hi everybody,

 

i have to replace a lot of values in the query and the function replace takes a lot of time since I have to enter manually both old and new value.

 

Is there a way I can just copy and and parte old and new values in a mask, and then Power BI replaces everything? 

 

See the file attached.

 

Thanks in advance.

 

Regards,

Andy

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
zoloturu
Advisor

Re: EDIT QUERY bulk replace

Hi @great_AS,

 

Read this article https://www.thebiccountant.com/2016/05/22/multiple-replacements-in-power-bi-and-power-query/

 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

1 REPLY 1
Highlighted
zoloturu
Advisor

Re: EDIT QUERY bulk replace

Hi @great_AS,

 

Read this article https://www.thebiccountant.com/2016/05/22/multiple-replacements-in-power-bi-and-power-query/

 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!