Forum Discussion

KimberlyHM's avatar
KimberlyHM
Frequent Visitor
4 years ago
Solved

New Column: If other table contains value

Hi guys!   Hopefully you can help with creating a measure 🙂 I want to add a New column in the Data tab in Table1 (could also maybe be the Power Query?). I have two data tables:   Table1 has 1 I...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    KimberlyHM,

     

    Try this calculated column in Table1:

     

    New Column =
VAR vID = Table1[ID]
VAR vTable =
    FILTER ( Table2, Table2[ID] = vID && Table2[Zero Section] = "yes" )
VAR vResult =
    IF ( ISEMPTY ( vTable ), "no", "yes" )
RETURN
    vResult
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 years ago

KimberlyHM,

 

Try this calculated column in Table1:

 

New Column =
VAR vID = Table1[ID]
VAR vTable =
    FILTER ( Table2, Table2[ID] = vID && Table2[Zero Section] = "yes" )
VAR vResult =
    IF ( ISEMPTY ( vTable ), "no", "yes" )
RETURN
    vResult
KimberlyHM's avatar
KimberlyHM
Frequent Visitor
4 years ago

Yes this worked perfectly, thank you!