Forum Discussion
Power Query Merge with multiple criteria
I have two tables, Sales and Payment. Both table have four columns. Sample is shown below: Sales Transaction Date Amount Bank Store 2/1/2020 3886 A ANC 2/1/2020 1163 A ANC 2/1...
Single Separate table, satisfying all the condition is perfect. However, you can provide any other solutions to get the merge data according to the mention criteria.
it looks like you're looking for something like this:
= Table.SelectRows(sales, each List.Contains(payment[Amount],_[Amount],(x,y)=>Number.Abs(x-y)<=5))
but it is only an attempt to interpret what you have written, because it is not clear at all to me.
if you want a possibly quick and useful answer, it would be preferable for you to provide examples of input and expected output.