Lists can be easily sorted using comparer functions, but sorting table column(s) with comparer functions is much more difficult. This post introduces a function that allows you to do this. One major reason to use this function is for sorting according to the rules of a specific language or locality.
Extra documentation for the native sort functions and comparers. It also gives some background information to a custom function I will introduce in the next post.
Column types in Power Query easily disappear i.e. change from type number to type any. Here are some code snippets and functions so that your column types stay intact.