Check if a value exist in another table

Question

Hi,i need to check if a value exist in another table that isn't directly relationed.&nbsp;&nbsp;Relations:PLM Parts Last &lt;----&gt;&nbsp; &nbsp; Req Transaction&nbsp; &nbsp;&lt;-----------&gt; BOM Header&nbsp;Lookupvalue didn't work&nbsp;&nbsp;&nbsp;while this worked:&nbsp;&nbsp;Why? Has lookupvalue some relations limitations?&nbsp;Thanks

jdbuchanan71 · Answer

It looks like you used a different lookup field between the two. 'PLM Parts Last'[WT Part Number] in the formula, 'PLM Parts Last'[Item Number AX] in the lookup. Does this work for the lookup?BOMheaderinERP = LOOKUPVALUE ( 'BOM Header'[Item Number]; 'BOM Header'[Item Number]; 'PLM Parts Last'[WT Part Number])

anonymous · Answer

Sorry wrong screen.&nbsp;Value are Item Number and WT Part Number.&nbsp;BOMheaderinERP = LOOKUPVALUE ( 'BOM Header'[Item Number]; 'BOM Header'[Item Number]; 'PLM Parts Last'[WT Part Number])Didn't work.&nbsp;Only the formula works but i don't understand how it works.

jdbuchanan71 · Answer

LOOKUPVALUE doesn't need a relationship at all.&nbsp; Any chance you can share your .pbix?

anonymous · Answer

lookup works but only if value is in the middle table (Req Transaction), if i manually search a PLM Parts Last value in BOM Header&nbsp; i will find it.&nbsp;I can't share pbix sorry.

anonymous · Answer

This works the same. Only value in middle table.&nbsp;I think it is a relations problem..

Forum Discussion

Check if a value exist in another table

5 Replies

Related content

Check column for similar values

Check if value is in another table - DAX

check if value contains in another table

Check if a value exist in another column

Calculated column checking if value exists in another table