Forum Discussion
Solved
Transposing data while joining multiple table in report
Hello All, I am new to power BI. working on a report creation where I need to join multiple tables and bring one table's data by transposing. Aware of Transposing option available in query edito...
Hi , mpk
After you merge "Name table" and "Account table ",please select the column" type " and click the function "pivot columns".
The result will show as below.
Here is a sample pbix file.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mpk , the order of operation is important, refer if these can help
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/