Creating one table from multiple tables

[cham]

Hi Team,

I have four tables called Acc, Lan, Conect and Contact

In Connect table has ID coloum which includes Lan ID and Acc ID records in that specific column. And Con ID coloum that can make a relationship with Contact ID coloum on Contact table

I want to create a table to show Acc Name, Lan and Contact ID but the issue is as the Acc ID and Lan ID is in the same coloum in Connect table I won't be able to get the data in table rows as attached image.

I need to show "eng and sin" in 3rd row as Con ID is the same for both the rows. Can you please let me know how I can do that.

[Ritaf1983 · Accepted solution]

Hi @cham 
You need to union these tables with power query or dax.
The tutorial on appending tables with PQ is on the link:

https://www.youtube.com/watch?v=xl2Cc8XugHU

Union with DAX :

https://www.youtube.com/watch?v=IPziqmQgJFw

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly