Forum Discussion

TrentS's avatar
TrentS
Helper IV
7 years ago
Solved

Lookupvalue help

I am returning to a previous issue (https://community.powerbi.com/t5/Desktop/Logic-help-IF-Switch-Contains/m-p/622072#M296983) with an update. (Thanks Greg for that previous help.) It works with the...
Need Help
  • TrentS's avatar
    TrentS
    7 years ago

    Thanks JSH, I will experiment with that. Might be a cleaner method and I can gain some education in it.

    I did find a solution just a minute ago. A combination of IF and ISBLANK works.

    = IF(
    ISBLANK(
    LOOKUPVALUE(Excel[Clean_Name], Excel[Customer_Name], 'Server'[Customer_Name])
    ), 'Server'[Customer_Name],
    LOOKUPVALUE(Excel[Clean_Name], Excel[Customer_Name], 'Server'[Customer_Name])
    ), 'Server'[Customer_Name]
    ))
TrentS's avatar
TrentS
Helper IV
6 years ago

Hi Anonymous ,

 

I created a plain pbix to test the syntax/logic and it seemed to work fine with both a value (7) not found in table and a value with a blank status.

I will try to take a peek at your file here shortly.

 

TrentS

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you TrentS! I also tried it in another sample file and the following logic works fine.

 

new status =
var lookup =
LOOKUPVALUE('table2'[status], 'table2'[ID], 'table1'[ID])
var compareVaraiable = BLANK()
return
IF(lookup = compareVaraiable, "No ", lookup)
 

I was able to assign values.  In that case,  am not sure why its not working for my main file. Do you have any guesses? The error is "A table of multiple values was supplied where a single value was expected."

 

Thanks for your help!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    That error means that there are repetitions in the ID column  on Table2.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you Ashish_Mathur. It works fine once i removed the duplicates

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        You are welcome.