cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Power Query help

Hi, 

Am trying to replace table 1 values with table 2 using power query but am getting error, can anyone help me please?

 

Capture 1.PNG

Condition to replace : in all the false cases (APP, CType, Tag

) of "sample" and "change" from table 1 should  replace with table 2 "sample" and "change" values where Type = Latest.

Thanks in Advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User V
Super User V

Re: Power Query help

Hi @yodha ,

 

I believe your sintax is not correct, there are 2 "each" on it.

Check this link: https://docs.microsoft.com/pt-br/powerquery-m/table-replacevalue

 

Also avoid the variables name like "Name One_".

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Power Query help

Hi @yodha ,

 

Please refer the operators list that can be used in power query in power BI.

https://docs.microsoft.com/en-us/powerquery-m/operators

 

You are using "and" in your query, which sjould be replaced with "&".

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Super User V
Super User V

Re: Power Query help

Hi @yodha ,

 

I believe your sintax is not correct, there are 2 "each" on it.

Check this link: https://docs.microsoft.com/pt-br/powerquery-m/table-replacevalue

 

Also avoid the variables name like "Name One_".

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors