Simple Question on Sorting

[Anonymous]

Hi Guys, 

Please bear with me here , as simple as it sounds it seems like a difficult task, 

I am trying to order the item column in ascending order for the same towermodelID

When I try to sort by column here  as below:

I get the following error:

Could Somebody please help me to sort the item column in ascending order for the same towermodel ID ?

[barritown · Accepted solution]

Hi @Anonymous,

If it is no problem for you that [TowerModelID] will be sorted in ascending order as well, you can the following:

- go to PowerQuery (Transform Data);

- sort [TowerModelID] somehow;

- press SHIFT and select [Item];

- sort [Item] in ascending order;

- save changes.

After that sorting of [TowerModelID] and [Item] should be synchronized in Table View: if you sort [TowerModeID] in descending order, [Item] will be sorted in the same order and vice versa.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian