Forum Discussion
Assemble equal data after using the function Table.ReplaceValue
Hello, In my dashboard I wrote a formula in Power Query to replace values according to two conditions like the example below: if it is an orange in France, then replace the orange by an apple. ...
Have you tried using trim as well as clean?
Failing that add a new step at end of power query to Replace "Apple" by "Test". Identify any rows that still have something that looks like Apple left which might give a clue.