Table Relations and non matched rows

[uthall]

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 occurs, i would like to have th row display something like "no value found".

For example, both tables are linked by a employee name field. The first table is the "master" employee table, with all employees in the table. The second table contains info on employees. but not all employees have an entry.

When the employee name from the first matches an entry in the second table, in want the info from both printed on the row in the table. When no match is found, i want the employee name from the first printed in the table, with "no value" as the value for the second table.

Possible?

[v-huizhn-msft · Accepted solution]

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