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 di...
  • 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!