why after saving and closing power Query, The order is different

[Anonymous]

Hi,

I did some group in power query, and sort Asset ID as 1st sorting, G/L Date as 2nd sorting, everything looks great (Picture 1). After I save and close powe rquery, the order of G/L date is different(picture 2). Anyone can tell me what happend, and how to address the issue?

thank you!

[Anonymous · Accepted solution]

After your sort step, use Table.Buffer to lock them in order. 

--Nate

[Anonymous · Accepted solution]

After your sort step, use Table.Buffer to lock them in order. 

--Nate

[Anonymous]

Hi Nate,

I thought it will work, but it didn't. Could you please help to check if I did it right? After I used Table.Buffer, and save and close PQ, the order of the date is still messed up.  😞

[Anonymous · Accepted solution]

You are awsome!