New Enterprise DNA Initiatives

Lookup table from another table Power BI

Hi,

I want to create a New Column in the Region table that pulls the US State: in the US States table using the Abbreviation column as lookup. How do I do that?

Police Shootings.pbix (267.2 KB)

Hi @YusufGillani,

You can do that with a Merge

Go to the Regions table, select Merge (1)
Identify the Keys (2) en (3) and press OK

.
Click on the side ward arrows (1)
Select the column(s) you want to add (2), don’t use original column name as prefix (3) and press OK
image
.
I hope this is helpful

2 Likes

Thank you so much!