Forum Discussion

Mederic's avatar
Mederic
Post Patron
1 year ago
Solved

Subtotals and Sort

Hello everyone, I tried to reproduce the exercise in the video in this link. The problem is that in my case, the sorting is done in the Product column but not in the other columns. For example, th...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    1 year ago

    Although I could not reproduce your problem with your data and your M-Code, Table.Group is not guaranteed to keep the original sort order.

     

    So I cannot test this workaround. However, I would try adding an Index column after the Main Table step (and deleting after the last step).

     

Mederic's avatar
Mederic
Post Patron
1 year ago

ronrsnfld , lbendlin ,

I've just tested it in Office 365 and no problem, the sorting is preserved (see screenshot below).
So it depends on the version of Excel
Have a nice evening

 

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    1 year ago

    Hi Mederic ,

    Glad that your query got resolved, please mark the helpful reply and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .


    Should you have any further questions, feel free to reach out.
    Thank you for being a part of the Microsoft Fabric Community Forum!