Forum Discussion

gaiusgw's avatar
gaiusgw
Helper III
5 years ago
Solved

LOOKUPVALUE with Direct Query or an alternative needed

I have looked through several similiar threads and am not finding a simple solution for this.    I am using 2 direct query sql soruces and I cannot change to import mode because I need the data to ...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    Glad to help. Can you mark one/more of these as the solution so this thread can be closed.

    On a semi-related matter, you don't need LOOKUPVALUE here either. You are thinking VLOOKUP in Excel. In Power BI, you should usually think merge. LOOKUPVALUE has its uses, but it is pretty rare - much rarer than doing any kind of VLOOKUP/XLOOKUP in Excel because of how merges and the data model works.

    See this file. It shows you how to merge those two tables and bring the TRUE/FALSE column into the first table. In Power BI, it the Transform button on the Home ribbon to get into Power Query to see it.

  • gaiusgw's avatar
    gaiusgw
    5 years ago

    Awesome! Thanks a lot edhans, really appreciate the advice. 👍

gaiusgw's avatar
gaiusgw
Helper III
5 years ago

Here is some more detail to make the issue clearer. 

 

Here you can see that my sources are directquery. So I am not able to edit unless I am using transform data. 

 

OPENDET is where I need to add the info to. 

 

OPENHEAD is where I need to pull the info from. I need the info in the BULK column. The common link is CONTROL_NO. 

 

Here you can see when I attempt to add a column and use LOOKUPVALUE, it is not recognized. 

 

Is there a way for me to pull the BULK info from OPENHEAD to add a column in OPENDET in transform data view?