Forum Discussion

edithb40's avatar
edithb40
Frequent Visitor
3 years ago
Solved

Check if value is in another table - DAX

I have two tables with a one-to-many relationship on the child's id. The table has other columns including the columns I have depicted below.  The two tables are: Child table child_id locatio...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Try creating a new column like

    new column =
IF (
    NOT ISBLANK ( 'child table'[location] ),
    IF (
        'child table'[location]
            IN SELECTCOLUMNS ( RELATEDTABLE ( 'parent table' ), 'parent table'[location] ),
        "Yes",
        "No"
    )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try creating a new column like

new column =
IF (
    NOT ISBLANK ( 'child table'[location] ),
    IF (
        'child table'[location]
            IN SELECTCOLUMNS ( RELATEDTABLE ( 'parent table' ), 'parent table'[location] ),
        "Yes",
        "No"
    )
)