Please help me on achiving below scenario

Hi newellaa ,Thanks for the quick reply, you are in the right direction.

Hi shafeeqva ,

The Table data is shown below:

Please follow these steps:

1.Create relationships between tables

2.Use the following DAX expression to create a column

Column = RELATED(City[City])

RELATED function (DAX) - DAX | Microsoft Learn

3.Final output

Best Regards,
Wenbin Zhou