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...
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
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
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.