Merge issue

[Anonymous]

Hello, 

I can't seem to fix this issue, below.   I am positive that both fields are of the same type.   Any ideas what could be causing this?    Anything to do with the order of query editor steps?  

[Anonymous]

Hi @Anonymous ,

The information you provided is not enough, I can only find a topic with same issue with you, hope it helps.

https://community.powerbi.com/t5/Desktop/Merge-error-quot-we-were-unable-to-determine-how-many-match...

Best Regards,

Jay

[GlauberCaires]

Hi,

Did you check if there is any null value in column or the data type is "ABC123" or the values in column arent distinct?

[amitchandak]

@Anonymous , Is this many to many join. If it giving OK button you can go ahead

[Anonymous]

No, on the Problem Codes table, the RMA_and_RMALine column is unique values.