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 Anonymous , dufoq3 ,

Thank you very much for your answers,
It helps me to correct my code..
However, the row for the total is missing.
And at the end, I'd like to sort the results according to 2 criteria
I'll explain all these points below :

1. 2. and 3. The sum total of rows 1 to 8 is missing
The GL Account will always have the account no. "23406400"
4. The text on the last row includes the word "Adjusting" & Years & Date reporting
5. The "Calculate Tax" column has a cross only on the last row
6. Sort the table by year and by GL Account

 

And above all, how can I have a step that groups together most of the steps, for example all the "Table.AddColumn" in a 3 or 4 steps ?
A much more elegant code than mine

Thanks in advance

Best regards