Custom Column to lookup "Region" value from another table and populate new column

[StuartSmith]

I have a table called "Table: Public Holidays" that has a country column, but I also need a "Region" column.

I have another table called "Table: Time to Fill" that has "Region", "Country", etc.

Is there a way to create a column called "Region" in the "Table: Public Holidays" table, then auto populate it by looking at the  "Table: Time to Fill" table to get the "Regions" for each "Country"?

Thanks in advance,

[miTutorials]

Please check this tutorial where I have explained exactly this.

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

[Smalfly]

Hi @StuartSmith ,

You can merge the 2 tables and only keep the region column from 'Time to Fill'.

Please check this tutorial to find out more.