Currently you can choose to sort based on another column, such as sorting a month name by the month number. However, this option does not exist in direct query mode. Please extend this functionalit...
Sort by column appears for me using DirectQuery, but appears to be limited to non-calculated columns. So for example, I have a text column I'd like to sort in a specific way, and I've created a calculated column to specify the sort order. When I try to sort the text column by the calculated column I get an error saying: "This column can't be sorted by a column that is already sorted, directly or indirectly, by this column." This is no good. Please fix!!
