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]
    ))
jsh121988's avatar
jsh121988
Microsoft Employee
7 years ago

I didn't read your whole issue, but I read your logic and summary. Try this:

CalcColumn = // On the Server table 
VAR sCleanName = LOOKUPVALUE(Excel[Clean_Name], Excel[Customer_Name], Server[Customer_Name], "NotFound")

RETURN IF(sCleanName = "NotFound", Server[Customer_Name], sCleanName)