Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

column to row relationship

Hi, I have two tables(table1 and table 2), the column names of table 1(1,2,3,4,5) is refering to values of table 2, how can we get a column(table1) to row(table2) relationship.   Table 1 1 2...
Need Help
  • mattbrice's avatar
    mattbrice
    9 years ago

    Unpivot Table 1 in query editor then relate 'Table 1'[New Value Column] to 'Table 2'[Values].

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    To relate two tales, there should have a common column in those two tables. In your scenario, you can open Query Editor, select the query Table1, select all columns then click Unpivot Columns.

     

     

     

    Then apply the changes, go to the report, create a relationship. For more information, please check attached .pbix file.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Anonymous,

 

To relate two tales, there should have a common column in those two tables. In your scenario, you can open Query Editor, select the query Table1, select all columns then click Unpivot Columns.

 

 

 

Then apply the changes, go to the report, create a relationship. For more information, please check attached .pbix file.

 

 

Best Regards,
Qiuyun Yu

cynthiaAA's avatar
cynthiaAA
New Member
5 years ago

Hello! Thank you for sharing this, it was very helpful and worked! But in the process I lost the data from the original Table1. Is there a way to unpivot, create the relationship, and then transform back to the original table while maintaining the new relationship? I tried pivoting, but it didn't work.