New Enterprise DNA Initiatives

Lookup table from another table Power BI


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
I hope this is helpful


Thank you so much!