Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.