Forum Discussion

knagar_5's avatar
knagar_5
New Member
3 years ago
Solved

Calculated column based on different table using Contains (or anything similar)

Hi   I am having problems creating a calculated column based on a column in a different table using the 'contains' function. I either get an error or '[List]'. I want to create a field in tablea th...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Newfield CC =
IF ( CONTAINSSTRING ( RELATED ( Tableb[field1] ), "x" ), "new", Tablea[field1] )
knagar_5's avatar
knagar_5
New Member
3 years ago

Thank you!