Forum Discussion
How 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.
Hi E5254730
If I understand you correctly, you have two tables, one with last week's data and the other with this week's data? And then you want to display them in the same table? Could you please provide some data so that I can help you better?
How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots. Please remove any sensitive data in advance.
Best Regards,
Yulia Xu
I'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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.