Power Query data merging problem

[RasW]

I need to merge two tables: sales $ values and the quantity. The first table has quantity and I am trying to get sales $ values from the second table. Both tables have 12 matching fields. I am getting an error "power query merge dataformat.error we couldn't convert to number detail 'c1'". I removed all errors and blank rows from my data. Still, I cannot merge those data. 

[Anonymous]

Can you post some sample data and some M code?

[RasW · Accepted solution]

Thank you for your quick response. Since I am not authorized to share my data I was preparing a mock sample set. Then I found my original data have some empty cells. (I removed empty rows/errors in later steps, somehow it didn't help and I got an error when I was merging two data sets).

I replaced those empty cells with zeros in the original data, then the problem was solved. 

Again thank you very much for your willingness to help. I am new to Power Query, I may need your help in the future.

Thank you!