Forum Discussion

Copper Contributor

Jul 10, 2020

Power Query sort ascending or descending based on a parameter

Hi all, What do i want: To sort based on a parameter in power query Why I am grouping records, the top record in each duplicate determines which value will be used; in ascending it will be...

BI & Data Analysis

SergeiBaklan

Diamond Contributor

Jul 11, 2020

CareLess

In Power Query global constants are equal

Order.Descending to 1

Order.Ascendinng to 0

Thus with parameter that could be like

Sort_AscDesc = 0,
#"Rijen gesorteerd" = #!"Table.Sort(#""Lege rijen verwijderd"",
   {{""Craft"", Order.Ascending},
    {""Cost"", Sort_AscDesc},
    {""Seed.Lvl"", Order.Descending}}
)",