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,
You can create an index column in query editor for Table 2 and then join it with Table 1.
Then you can use RELATED function in DAX to get the desired column.
Color = RELATED( Table2[ Color ] )
Thanks.
thanks, however i am looking to join using query not DAX, and i understand how to join using the merge and a unique key.
I am trying to combine the tables as if there were no relationship between the two tables. if you imagine copying one column and pasting it next to the other in excel terms
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 |
---|---|
108 | |
105 | |
87 | |
74 | |
67 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |