How to sort according two different conditions in a table?

[youneskil]

Hi guys,

in my table you see several columns. Two of them are sequencenumber and cycle.
Is it possible to create a new table with the same columns but where the rows are sorted by sequencenumber and by cycle?


It shall look like this:

cycle	squencenumber
MBM_01	383778
MBM_02	383779
MBM_03	383780
...	...
Thank you for your help!

 

[alansidman]

We are unable to manipulate data in a picture. Please reload your sample data using XL2BBB. See my signature for instructions.

 

[youneskil]

I would love to do so but I have no Excel Data. The data is from the Web and directly imported into Power Bi.
Is there an opportunity to export data from Power Bi to Excel?

 

[alansidman]

In Power Query, on the Home Tab. Close and Load To

 

[youneskil]

In Power Query, on the Home Tab. Close and Load To

My company does not have a Power Querry license. I can only use the standard Version of Power Bi or Excel.
Or do you mean the Power Querry Editor in Power Bi? There I have the buttons "close", "close and apply" or "apply", but no "close and load to".

 

[alansidman]

PQ editor. What version of Excel are you using? Please update your profile as this will make it easier to understand how best to help you.

 

[youneskil]

We got the standard office 365 version. The Add in list in our Excel 2016 does not include Power Querry or any other "special" tool.

 

[alansidman]

In Versions 2016 and later, Power Query is part of the native Excel. It is called Get & Transform Data and is found on the Data Tab. It is not an add-in. It was an add-in in versions 2010 and 2013.

Look at the link in my signature.