Forum Discussion

Mederic's avatar
Mederic
Icon for Post Patron rankPost 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

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
Icon for Post Patron rankPost 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