• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power query sorting is different from the Excel sorting

Lolo

Member
Hello,

I'm facing with an annoying issue with power query sorting action.
Seems Power query sorting manage differently the special chars than Exel in the sort.

LEt me explain with a basic example :
I have a table with the basic following values, unsorted

Col1
val1
¨val1
_val1

If in Excel I sort ascending the table by Col1, result is :
Col1
_val1
¨val1
val1

and it is the result I expect.

If these data are now in power query, I execute the sort in power query with Table.Sort instruction and load data to workbook
the result is now :
Col1
_val1
val1
¨val1

You can find attached the workbook

So the Excel sorting is different from the Powerquery sorting, which cause some issues for me :(

Any idea on how I can use power query and having the excel sorting behavior ?
The single workaround found is to create a macro that refresh power query table, and after sort the result in excel :(

Thank you for your help.
 

Attachments

  • Classeur1.xlsx
    17.3 KB · Views: 1
Back
Top