Forum Discussion

JillK2468's avatar
JillK2468
New Member
3 years ago
Solved

Sort using parameter as descending vs ascending

I have a parmater that specifies descending or ascending.  The parameter name is #"Select Sort Order".  I want the parameters value to be passed to Table.Sort() so that the order.type argument is Order.Descending or Order.Ascending.  When I do the following query I get an error.  I need help in finding a solution.

 

= Table.Sort(Source,{"Year",("Order." & (#"Select Sort Order"))})

 

The error is the following:

Expression.Error: The specified sort criteria is invalid.
Details:
[List]

 

  • Hi, JillK2468 Use 1 and 0 instead if strings. Behind Order.Descending and Order.Ascending are 1 and 0. Order.Descending = 1, Order.Ascending = 0.

2 Replies

  • Hi, JillK2468 Use 1 and 0 instead if strings. Behind Order.Descending and Order.Ascending are 1 and 0. Order.Descending = 1, Order.Ascending = 0.

    • JillK2468's avatar
      JillK2468
      New Member

      Wonderful! That is great to know that it is binary.