Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 editor but not able to make it work as need to join multiple tables.
See highligthed columns in final table[ Coming from Account table ]. Please help. Left side in picture shows source tables in model and right side is final table structure needed.
Solved! Go to Solution.
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.
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/
https://radacad.com/pivot-and-unpivot-with-power-bi
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |