cancel
Showing results for 
Search instead for 
Did you mean: 

Solved - Power Query table merge results "not existing" value

Hi,

I merge two tables with left outer join and it is bringing false result.

 

Here is my example: 

I have a dummy "Table" with one row that I merge with table "Payment data" to get the value date.

Payment data table originally had duplicated rows and I kept only those lines that had the latest Value date. For the example I additionally filtered it down to the only one row that I would like to see in the result after the merge (as you can see on the screenshot).

 

Making the merge I am getting a result where the value date is 16/01/2020 (instead of 22/01/2020) that I already filtered out long before from Payment data table.

InkedScreenshot_2_LI.jpg

Why? It should not be like this.

 
Status: New
Comments
New Member

I kept looking for answer and finally found the solution: 

As I used Index in the payment data to keep only the latest Value date I need to add a Table.Buffer() in the end of the query.

 

I found the solution here:

https://community.powerbi.com/t5/Desktop/Merge-problems-incorrect-expand/td-p/442443/page/2

 

Community Support

@matyas 

 

Glad to hear that. Thanks for sharing the solution.