Power Query help

[yodha]

Hi, 

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

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!

[camargos88 · Accepted solution]

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_".

[Pragati11]

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