Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Making a VLOOKUP-esque column in Power BI

Hi there,   I have a large set of data, consisting of migration flows between different jurisdictions.   The jurisdictions are denominated by a code, e.g. 'E09000021', of which there are hundreds...
Need Help
Tips and Tricks
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello Anonymous 

    You can use LOOKUPVALUE.  In your DetailTable add a calculated column like so:

    Jurisdiction Name = LOOKUPVALUE ( NameTable[Jurisdiction Name], NameTable[JurisdictionCode], DetailTable[JurisdictionCode] )
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

Hello Anonymous 

You can use LOOKUPVALUE.  In your DetailTable add a calculated column like so:

Jurisdiction Name = LOOKUPVALUE ( NameTable[Jurisdiction Name], NameTable[JurisdictionCode], DetailTable[JurisdictionCode] )