Forum Discussion
Solved
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 wit...
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.
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