Power Query Heirachy Sort

[gazmoz17]

Hi,

Is this possible as you would do in excel?

Heirachy sort:

1. Customer
2. SKU

However, after doing the 2nd sort step it forgets sort 1 (prior step) altogether.

Thanks

 

[johnny51981]

You can do this by separating them by a comma within the same Sort step.

= Table.Sort(#"Previous Step",{{"Customer", Order.Ascending}, {"SKU", Order.Ascending}})

 

[gazmoz17]

Argh thanks Johnny I knew there was no way this couldnt be done such a simple requirement.

 

[GraH]

Default sorting of PQ is hierarchical. The UI does what Johnny wrote in his code. I wonder how you tried to the sorting then?

 

[johnny51981]

At least in my version, you are prompted to either update the existing step or create a new one. It isn’t always default to be in the same step.