Forum Discussion

v4anand18's avatar
v4anand18
Advocate I
8 years ago
Solved

Sorting a table using multiple columns

Hi All,     Is it possible to sort a table using multiple columns?       My table looks like this and i would like to sort by "Year" first and then by "Month". Is it possible?
Need Help
  • StevePBennett's avatar
    StevePBennett
    4 years ago

    I see this tread is quite old, but sorting a visual by one column and then a second column is as simple as clicking the 1st column header to sort ascending or decending. Then simply hold the <Shift> key down and click on the header of the second column.
    Of course you can just keep the <Shift> pressed and click on a 3rd, 4th etc until happy. 

    I hope this helps. 
    Steve B

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi v4anand18,

 


Can you mark the proper answer as a solution please?

 

Best Regards,

Dale

  • v4anand18's avatar
    v4anand18
    Advocate I
    8 years ago

    Hi 

     

     

     

     

    • roopsnegi's avatar
      roopsnegi
      Regular Visitor
      7 years ago

      Hi,

      I am trying to apply this step in my query editor as a step, but it throws an error. Could you please suggest how to resolve it.

      Expression.Error: The name 'Changed Type' wasn't recognized.  Make sure it's spelled correctly.

       

      Thank you,

      Roopali

      • Thejeswar's avatar
        Thejeswar
        Super User
        7 years ago

        Hi roopsnegi,

        There is a break in your steps present in the Query Editor.

         

        Check if all the steps are properly linked to each other. In simple words, there is a problem (mostly name related) with the steps before, in or after the Changed Type Step. 

         

        If you post the M-Query of your query, it will be easy to solve this error....