Power BI power Querry: how to enhance rows with other data (number of rows grow)

[Pete230]

Hi together;

Im sturggeling since a few days with the following szenario.

This is my input data (table 1): Towns and Dates:

Name	Date
Capetown	10.11.2023
Paris	09.11.2023
Copenhagen	08.10.2023
Copenhagen	15.09.2023
Copenhagen	17.09.2023

I would like to enhance this (table 1) with IDs, each town has 2-3 IDs which can be found in another table (table 2):

City	ID
Capetown	abc
Capetown	def
Paris	ghi
Paris	jkl
Paris	mno
Copenhagen	pqr
Copenhagen	stu

so the result looks like this (table 3):

City	ID	Date
Capetown	abc	10.11.2023
Capetown	def	10.11.2023
Paris	ghi	09.11.2023
Paris	jkl	09.11.2023
Paris	mno	09.11.2023
Copenhagen	pqr	08.10.2023
Copenhagen	stu	08.10.2023
Copenhagen	pqr	15.09.2023
Copenhagen	stu	15.09.2023
Copenhagen	pqr	17.09.2023
Copenhagen	stu	17.09.2023

does anyone know how to achive this?

Would be great!

Cheers, Pete

[miTutorials]

In case you need a video tutorial on Merge queries here it is !!

How to Join Tables | Merge Columns and Append Rows in PowerBI | MiTutorials - YouTube

[kleigh · Accepted solution]

Merge Queries:

Merge queries (Power Query) - Microsoft Support

[Pete230]

That one was easy, thanks!