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