Forum Discussion

mpk's avatar
mpk
Frequent Visitor
6 years ago
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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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.

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

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.