Forum Discussion
chronis69
Microsoft Employee
Microsoft Employeesimple 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
Super User
Super UserHi 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.
chronis69Microsoft Employee
Microsoft Employee- MFelix
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