Forum Discussion
chronis69
6 years agoMicrosoft Employee
simple tables join
hi I want to do a simple join of 3 tables who dont share any common field they just have the same number of rows. I have table 1= a b c table 2 = 1 2 3 I want a table that wou...
MFelix
6 years agoSuper User
Hi chronis69,
Assuming that they both are in the sorting you need.
Add an index colum to each table then make merge based on index of both tables.
Assuming that they both are in the sorting you need.
Add an index colum to each table then make merge based on index of both tables.
chronis69
6 years agoMicrosoft Employee
- MFelix6 years agoSuper User
Hi chronis69 ,
This should be done in the query editor using the merge option:
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-queries