Forum Discussion
JillK2468
3 years agoNew Member
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.