Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Lookup value with multiple condition

Hi all,

 

How can I lookup "Unit Cost" value in Table B into Table A? FYI, all the 3 column have duplicate value.

Already try advanced merge in power query but not possible.

 

 

Regards,

Nuha

 

General Comment
Need Help
Show and Tell

3 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    try something like:

     

    Measure = LOOKUPVALUE('Table B'[Unit Cost],'Table A'[Process Code],SELECTEDVALUE('Table B'[Process Code]),'Table A'[Item Name],SELECTEDVALUE('Table B'[Item Name]),'Table A'[Category],SELECTEDVALUE('Table B'[Category]))
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi DOLEARY85 ,

       

      I'm facing below error. Any idea?

       

       

      Regards,

      Nuha

       

      • DOLEARY85's avatar
        DOLEARY85
        Resident Rockstar
        3 years ago

        Sorry if the other table is outside of the table with the value you are looking up use selectedvalue() around it - looks like i put table A & B in the wrong order after the intial field.