Transposing data while joining multiple table in report
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.