Forum Discussion
Helper IIHow to create relationship between 2 tables having same columns in both tables
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper III've added a small set of data in table format. But this is not properly showing in table format.
Sending the screen shot as well:
Prior Week:
Current Week:
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
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.