Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |