Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Is this person found on that table? DAX code help

Hi, DAX newbie here.  Apologies if this is really simple, but my googling hasn't helped me get this right! I'm attempting to create a calculated column in [Employee List] that returns the value "Ye...
  • lbendlin's avatar
    lbendlin
    6 years ago

    The relationship between the tables is actually 1:1 with bidirectional search .

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

check = not isblank(related(promotions[idnumber]))

 

(assuming a M:1 relationship from employee to promotion. Otherwise check the lookupvalue() against blank() )

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you very much for responding.  Unfortuately it is not working, would this be because the promotions list isnt a full list like the full employee list?  It is only people who were promoted, so the ISBLANK isn't looking for matches where a value is blank, just the existence of a match...?

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    show your data model, show some sample data and the expected outcome please. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

      Here is an example of my tables.  Table 1 is a list of everyone.  Table 2 is a list of just some people.  The yellow is what I wish to insert, a calculated column on Table 1 if their employee ID is also found in table 2.   The two tables are linked through the employee ID.

      Thanks.

       

       

       

       

       

       

       

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        6 years ago

        The relationship between the tables is actually 1:1 with bidirectional search .