Forum Discussion

abhitiwa's avatar
abhitiwa
Icon for Helper I rankHelper I
8 years ago

Lookup a value in other table - DAX

I have a table A with duplicate values in one column. I want to run a vlookup in another table B, and want to return 'TRUE' if it exists in table A. eg below-    TABLE A :: ID       amount 1     ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI abhitiwa,

 

You can add a calculated column with below formula to check exist item based on other table:

 

Check = [ID] in VALUES(Records[ID])

 

Regards,

Xiaoxin Sheng

  • nickchobotar's avatar
    nickchobotar
    Icon for Skilled Sharer rankSkilled Sharer
    8 years ago

    Anonymous

     

    That's great. Another way is to wrap VALUES() into a CALCULATE() for context transition.
       *** works with relationship only, though