Forum Discussion
Merge Queries w/ Like Columns Issue
Hello, I am trying to merge two datasets and have it a wall with matching like values, even though I do have matching values in the referenced table. Purpose: Perfrom a left outer Join Kind...
Make sure you do a Trim and Clean on the columns of both tables before Merging. Often there can be trailing spaces and such that cause issues.
Although not the issue here, perhaps it's worth reminding Power Query join are case-sensitive, while DAX joins are case-insensitive.