If I Have 4 Related Tables, How To Get All Of Their IDs in a Single Column?

[I_NeedMorePower]

Hello Power people!

I have 4 tables, for example: table1, table2, table3 and table4.

and each table is related to the next table. Like a heirarchy. For example:

table1---> table2 ---> table3 ---> table4

Each table has it's own Primary Key (ID), and what I want is to get all these 4 ID columns into one column.

It's because I want to create a heirarchy chart but since the data is seperated into 4 tables, I'm not being able to use the PATH function. I want to create a table which contains a column for IDs and another column that contains their Parent ID. So I can use the PATH function.

Is this possible?

Thanks in advance!

[timg · Accepted solution]

Hi,

You could solve this by doing a merge on the above mentioned tables in Power query. e.g. merge table 1 on 2, then merge the result with table 3, etc. Below you will find an example of three tables merged into one. 

Regards,

Tim

[amitchandak]

@I_NeedMorePower , Merge in power query and keep the required column and append them in one column

https://radacad.com/append-vs-merge-in-power-bi-and-power-query