Forum Discussion
Merge query is acting weird
Hi GuilleATT ,
the behaviour you're seeing would happen if you don't use a Table.Buffer when sorting before removing duplicates: https://community.powerbi.com/t5/Community-Blog/Bug-warning-for-Table-Sort-and-removing-duplicates-in-Power/ba-p/810390
GuilleATT - Can you post sample data or a link to your PBIX? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi GuilleATT ,
the behaviour you're seeing would happen if you don't use a Table.Buffer when sorting before removing duplicates: https://community.powerbi.com/t5/Community-Blog/Bug-warning-for-Table-Sort-and-removing-duplicates-in-Power/ba-p/810390
Awesome, that worked, thank you so much!
