Forum Discussion
Check if a value exist in another table
Hi, i need to check if a value exist in another table that isn't directly relationed. Relations: PLM Parts Last <----> Req Transaction <-----------> BOM Header Lookupvalue didn't wo...
Sorry wrong screen.
Value are Item Number and WT Part Number.
BOMheaderinERP = LOOKUPVALUE ( 'BOM Header'[Item Number]; 'BOM Header'[Item Number]; 'PLM Parts Last'[WT Part Number])
Didn't work.
Only the formula works but i don't understand how it works.
LOOKUPVALUE doesn't need a relationship at all. Any chance you can share your .pbix?
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 i will find it.
I can't share pbix sorry.
This works the same. Only value in middle table.
I think it is a relations problem..