how do i create relationship without colum values matched

[rammy]

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

[v-zhangti · Accepted solution]

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.

[amitchandak]

@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