Forum Discussion

E5254730's avatar
E5254730
Helper II
2 years ago
Solved

How to create relationship between 2 tables having same columns in both tables

Hello, Trying to attach excel for your reference, but do not see the option of upload Below is the output I'm looking to achieve. My both the tables has same columns. In Current week - line ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi E5254730 

     

    I would like to apologize for the belated reply.

     

    You can try the following:

     

    1. Create a calculated table as follows:

    Table = VALUES('Current week table'[Category])

     

     

    2. Create relationships as follow

     

     

    Output:

     

    You can also make changes to the column names. Double-click the corresponding column.

     

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi E5254730 

 

I would like to apologize for the belated reply.

 

You can try the following:

 

1. Create a calculated table as follows:

Table = VALUES('Current week table'[Category])

 

 

2. Create relationships as follow

 

 

Output:

 

You can also make changes to the column names. Double-click the corresponding column.

 

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

E5254730's avatar
E5254730
Helper II
2 years ago

Thanks!

This gives the desired output.

But I'm assuming, apart from Category column, if there are other columns, say - Status Column, I'll have to create another table similar to Category table and create a relationship

 

Thanks, once again.