Forum Discussion

Mat42's avatar
Mat42
Resolver I
5 years ago
Solved

Convert Table Sections into Columns

The heading might be a bit misleading, but I can't really think of another way to put it.   I have a huge dataset, all housed on Sharepoint, that is horribly structured. It is comprised of hundreds...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Mat42 ,

     

    According to your needs, you can achieve the results you expect in Power Query.

    I did the following test, which can be used as a reference: "Reference" a new table in the query, and then do the following steps

    Then create the index column and merge the table through the index column.

    Finally put the corresponding lot on the table visual to get the desired result

    Here is a relative link for referene:Solved: Filter rows in Query editor - Microsoft Power BI Community

    Here is the sample pbix file.


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Super User
5 years ago

Mat42 I think I got the gist. The solution is attached, basically, I'm taking 3 blocks into separate tables and merging those together. if for some reason, performance is an issue because of merging, we can completely ignore it and create a relationship between tables but let's start with this. Test it and let me know if this is what you are looking for.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡