IF Statement Using Lookup Table

[markefrody]

Hi,

I need some assistance in creating an IF statement in DAX using a lookup table.

Here is a sample of the main table: 

Here is a sample of the lookup table:

Here is the output that I need. Column "Origin Check" will check whether any of the places matches with the "Lookup". It will return "Yes" if it matches, "No" if it does not match. 
Same logic as "Origin Check" also goes for column "Destination Check".  Return "Yes" if it matches, "No" if it does not match using the "Lookup" table.  

Appreciate your kind assistance.

Thanks and best regards,
Mark V

[markefrody]

Thank you for the help guys! 

[Ashish_Mathur · Accepted solution]

Hi,

Use these calculated column formulas in the Main table.  They will work even without a relationship between the 2 tables:

Origin check = if(isblank(lookupvalue('Table2'[lookup],'Table2'[lookup],'Table1'[Origin])),"No","Yes")

Destination check = if(isblank(lookupvalue('Table2'[lookup],'Table2'[lookup],'Table1'[Destination])),"No","Yes")

Hope this helps.

[tamerj1]

Hi @markefrody 
Assuming no relationships, you create a calculated column in the 'Main Table'

Origin Check =
IF ( 'Main Table'[Origin] IN VALUES ( 'Lookup Table'[Lookup] ), "Yes", "No" )

[NilR]

Calc column = IF(RELATED('main table'[Destination])='Dim Table'[Destination]),"Yes","No") 

you also need to create relationship between tables.

https://www.wallstreetmojo.com/power-bi-related/