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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
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.