Question

What is the M language function to sort a column in the query editor?​

Answer 1

Sort a table in Query Editor based on a single column. In Query Editor, select the column you want to sort on. From the drop-down menu, click Sort Ascending (from low to high) or Sort Descending (from high to low).

Answer 2

The M language function to sort a column in the query editor:

Explanation:

• We create a data transformation in the power query editor UI.
• To sort a query in Access in the query design view then click into the Sort” row of the field in the grid.
• Then we use the drop down which appears to select either Ascending or Descending order.