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 .

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago
// If the Promotions table is linked
// to the Employees table via the field
// [ID], this then should most likely 
// be a many-to-one connection because
// a person could be promoted many times.
// The structure therefore should be
// Employees 1 - * Promotion.
// If that's the case, it easy to create
// the calculated column.

[Ever Promoted] =
IF(
    ISEMPTY( RELATEDTABLE( Promotions ) )
    "No",
    "Yes"
)

Best

D