Forum Discussion

Stian Egge's avatar
Stian Egge
Copper Contributor
Oct 19, 2018
Solved

Power Query Editor sort changes order on rows with same value

Hi!   I'm having a problem with the power query editor sorting rows it should not change order on. My goal with PQE is to show a summary of tasks from a "mission log", sorting based on two seperate...
BI & Data Analytics
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 19, 2018

    Hi Stian,

     

    Right after sorting PRI sort NR column as well. In the formula bar you'll see like this

    = Table.Sort(#"Previous Step",{{"PRI", Order.Ascending}, {"NR", Order.Ascending}})

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 19, 2018

Hi Stian,

 

Right after sorting PRI sort NR column as well. In the formula bar you'll see like this

= Table.Sort(#"Previous Step",{{"PRI", Order.Ascending}, {"NR", Order.Ascending}})

 

  • Stian Egge's avatar
    Stian Egge
    Copper Contributor
    Oct 19, 2018

    Thanks a lot, that worked!

Resources