Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Adding column based on value from other table

I am attempting to essentially do a VLOOKUP in Power BI. I am trying to create a column that adds a supplier's name. The tables that I am using for this do not have the information required in the cu...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    What I suggested should work for calculated columns but with a measure, it doesn't automatically know which id value you want to look up (since there isn't the same row context that exists for a calculated column).

     

    Try adding an aggregation as the error message indicates:

    LOOKUPVALUE (
    item[supplier_name],
    item[supplier_id], SELECTEDVALUE ( invoice[supplier_id] )
)
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

The LOOKUPVALUE function works pretty similarly to VLOOKUP.

 

Try something along these lines:

LOOKUPVALUE (
    item[supplier_name],
    item[supplier_id], invoice[supplier_id]
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    When I atempt to use that function, I am getting this error. Do you know what could be causing this? 

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      4 years ago

      What I suggested should work for calculated columns but with a measure, it doesn't automatically know which id value you want to look up (since there isn't the same row context that exists for a calculated column).

       

      Try adding an aggregation as the error message indicates:

      LOOKUPVALUE (
    item[supplier_name],
    item[supplier_id], SELECTEDVALUE ( invoice[supplier_id] )
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Can I use this formula but add a true and false / IF THEN statement. Basically sating if this column equals "0" then pull the data from another column. If it is possible, how would it look?