Expand table give wrong value

[SteveDesmedt]

I have a strange behaviour after expanding a merged query.

I've created a table (EUCHISTORY) giving the following results

So far all is working as required

Now i've merged this table with the table EUCDECLARATION based on DECLARATIONGUID

Still is still the expected result.

But, when i expand the table, i receive following result.

This is not the expected result.  

Current Result   =  DMSACC/DMSCLE/DMSTAX

Expected Result =  DMSACC/DMSTAX/DMSCLE

This is driving my crazy.

Someone any solution or sugestion.

Much appreciated.

Steve

[Syndicate_Admin]

Power Query does not give any sorting guarantees. If your expected order differs from an alphabetic order then you need to bring your own index column.