New to BI, VLookup alternative?

[jcawley]

Hello,

I'm new to Power BI and trying to... Make a V-Lookup of sorts. How can I create a column that looks to see if a value on table1 appears in a table2 in a different column? I just would like it to return "Yes" or "No" depending if the value exits.

Table1

ID	ID Exists in Table2?
12345
23456

Table2

Exchange ID	ID
11111	12345

Any help would be greatly appreciated

[amaleranda]

@jcawley ,

Below is calcualted column is based on one to many relationship based between Tabel1(One) and Tabel 2(Many).

Please accepet it as a solution if it fits your requirment.

[amitchandak · Accepted solution]

@jcawley , A new column in Table 1,

In case tables are related 1-M from Table1 to table 2

if(isblank(realted(Table2[ID])),"No", "Yes")

Or

if(isblank(countx(filter(Table2, Table2[ID] =Table1[ID]),Table2[ID])),"No", "Yes")

[jcawley]

Thank you! The second one worked for me.

[az38]

Hi @jcawley 

LOOKUPVALUE() https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

or calculate countrows. in your case it will be like

Column = 
var _isValue = CALCULATE(COUNTROWS(Table2), FILTER(Table2, Table2[ID] = EARLIER(Table1[ID])) )
RETURN
IF(_isValue > 0, "yes", "no")

[jcawley]

Thank you! This solution worked for us as well!