Forum Discussion

Mederic's avatar
Mederic
Post Patron
2 years ago
Solved

Data table transformation

Hello everyone, I need, please, your help in Power Query This topic is another transformation model with an identical table to the topic I posted here. I tried to take inspiration from dufoq3's ...
Need Help
  • Mederic's avatar
    Mederic
    2 years ago

    Hello everyone,
    I have a 3rd approach with Data_V3 which almost satisfies me but I think we can do better.
    I also have to sort by "Year" and by "GL Account", which I don't know how to do.

    - Power BI File

    Thank you in advance for any help or solutions

    Best regards

Mederic's avatar
Mederic
Post Patron
2 years ago

Hello everyone,
I have a 3rd approach with Data_V3 which almost satisfies me but I think we can do better.
I also have to sort by "Year" and by "GL Account", which I don't know how to do.

- Power BI File

Thank you in advance for any help or solutions

Best regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Mederic 

     

    Great! Every step forward is appreciated. The sorting will be easy. You can insert a step for sorting by Repair Date and GL Account columns before the last step which gets the total row. Just like below. 

    = Table.Sort(#"Lignes groupées",{{"Repair Date", Order.Ascending},{"GL Account", Order.Ascending}})

     

    Best regards,

    Jing

    • Mederic's avatar
      Mederic
      Post Patron
      2 years ago

      Hello Anonymous ,

      Thank you for your reply.

      I thought I'd already tried this before and thanks, it works.
      I must be tired 😊

      Best regards