SORT Numbers and Text Mixed as per correct Numerical Order in Power Query
Say Column Values are - 1Apple, 10Lichi, 3Grapes. If we Sort this Column in Ascending Order from the SORT option available in the UI, resultant Column Values will be - 10Lichi, 1Apple, 3Grapes. This is because the numbers in each Value are treated as Text and Sorted accordingly.
Our desired result is - 1Apple, 3Grapes, 10Lichi.
In this Video, we shall see that how we can get to our desired result using an Additional Parameter in Table.Sort M Function. Similar Idea can be extended to List.Sort as well.
To learn more Custom Sorting in Power Query in detail, checkout the following Blog and Video by @BIGorilla :
Blog - https://gorilla.bi/power-query/how-li...
Video - • Understanding List Sort in Power Query
