I have big issue with Merging Queries function (power query ).
I have 2 tables:
1.Table A => Fact table
2.Table B => Duplicate from Fact table
I join by left outer join from Table B into Table A. (Table A is the left table)
as you can see in table B the numbers sort from A-Z
however , After merge to Table A their is mess with the numbers.
In the bottom line I want to join Table C to A
Links attached -
Hope for your responds
In the first line it is sorting alpahbetically, in the second it is sorting numerically. My guess is that there has been a type change that was automatically done that changed the column from a text column to a number. This should appear as a change type step in the query editor.