Forum Discussion
IF Statement Using Lookup Table
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
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.
4 Replies
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" )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.
Calc column = IF(RELATED('main table'[Destination])='Dim Table'[Destination]),"Yes","No")
you also need to create relationship between tables.
Thank you for the help guys!
