Forum Discussion

Sohail-Merchant's avatar
Sohail-Merchant
Regular Visitor
6 years ago

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...
Need Help
Show and Tell
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Sohail-Merchant 

 

Would you mind to produce a table with the expected result?

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • Sohail-Merchant's avatar
    Sohail-Merchant
    Regular Visitor
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.