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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Mederic 

 

It seems that you already get close to the desired outcome through the M code. Where do you want to make it dynamic? In earlier steps, you use some "not dynamic" code get the following column, 

so I update the code a bit to make it dynamic by using Merge queries feature to finally get the following Item Text column. See Data (2) query in the attachment. Hope this would be helpful. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!