Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |