Forum Discussion
how do i create relationship without colum values matched
Hi Power bi Community
The scenario is i have 2 tables in those two tables there is no matched column values were been their to create relation ship. how to create relationship between them without matching column values or do i need to create a column to make establish relationship
NOTE : data is fetching from sql
for your reference please sdee below snip
please help me
Thanks in advance
Hi, rammy
Maybe you can add index columns to each of your two tables. If the data source is SQL, you can use import mode.
This is how you can create a relationship between two unrelated tables.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
rammy , we need a common column to analyze them together. Usually, in nonmatching tables, we only have a common table - Date. We analyze those together with date and do the rest of the analysis separately
Hi, rammy
Maybe you can add index columns to each of your two tables. If the data source is SQL, you can use import mode.
This is how you can create a relationship between two unrelated tables.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
