Create a query with values from one table copied down rows to match values from another

[SK123456]

I have 2 tables and I am looking to have a query that will return a single table:

Name		Type		Name	Type
Name1		Type1		Name1	Type1
Name2		Type2		Name1	Type2
Name3		Type3		Name1	Type3
				Name2	Type1
				Name2	Type2
				Name2	Type3
				Name3	Type1
				Name3	Type2
				Name3	Type3

Preferably the end refult table would also be updated when I refresh my 2 based tables

Thank You

[v-diye-msft · Accepted solution]

Hi @SK123456 ,

I think you can refer to the merge queries: 

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-data

Here's a blog for your better understanding:

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

Best regards,

Dina Ye

[v-diye-msft]

Hi @SK123456 ,

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,
Dina Ye