Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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!

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

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

    --Nate

  • Anonymous's avatar
    Anonymous
    4 years ago

    You are awsome!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

    --Nate

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      You are awsome!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.  😞