Sort using parameter as descending vs ascending

[JillK2468]

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]

[AlienSx · Accepted solution]

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]

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