Forum Discussion
Merging in Power Query
Merge always gives me a headache. Situation is: I have a table of opportunities with an Opportunity ID. I have another table, called Quotes, that contains the Opportunity ID as well...but al...
have you checked the rowcounts on both tables? Is it not possible that a customer has more than one quote but then i suppose the opportunity id would be different? If not check for duplications. What are you joining on? best to share some of the data.
have you checked the rowcounts on both tables? Is it not possible that a customer has more than one quote but then i suppose the opportunity id would be different? If not check for duplications. What are you joining on? best to share some of the data.