Forum Discussion

uthall's avatar
uthall
Icon for Helper II rankHelper II
9 years ago
Solved

Table Relations and non matched rows

Hello,   I Have 2 related tables.   When i add fields from both to a table, rows where items in the first table are not match in the second table appear as blank or no values.   When this occur...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi uthall,

    You can add a calculated column in “master” table. I try to reproduce your scenario by creating “master” employee table like the first picture, and the information in second picture.

     


    Then add a calculated column using the formula below. Create a table, select the Employee and column as values, you will get the expected result.

     

    Column = IF(ISBLANK(RELATED(Table20[information])),"no value found", RELATED(Table20[information]))




     

     

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi uthall,

You can add a calculated column in “master” table. I try to reproduce your scenario by creating “master” employee table like the first picture, and the information in second picture.

 


Then add a calculated column using the formula below. Create a table, select the Employee and column as values, you will get the expected result.

 

Column = IF(ISBLANK(RELATED(Table20[information])),"no value found", RELATED(Table20[information]))




 

 

Best Regards,
Angelia