[ power query ] MERGE not working even though values are the same

Hi Anonymous ,

The values appear the same in that format, but in the background one is probably 5.520000000133 or similar.

I'd recommend applying Number.Round to both values before the merge and see if that helps.

Pete

Hi Anonymous,

I'm with BA_Pete on this one, that's most likely.

Generally there are a couple of things to look out for when a merge is not returning the expected result. 

1) The case of strings
2) The datatype of values
3) The addition of invisible characters like a space for example

4) The number of decimal places